RSI’s Post

Hello Associate, Greetings from eNcloud Services LLC We do have an Immediate Requirement for: Role: SSIS Analysis/Modernization Employment Type: W2/C2C Position: Remote Job Description: • Delphi Client Server system with user interface and business libraries. • COTS DevExpress Delphi user interface controls are widely used in SSIS.  • Most of the business rules (except user edit rules) are repeated in Delphi business layer and backend Oracle database. • Most of the users access SSIS client server through Citrix XenApp/Azure Virtual Desktop. • Through database consolidation initiative, County SSIS databases are centrally located in different schemas in Oracle. • Case access management by another County is done by submitting a request in SSIS. • Most of the integration and interoperability is done in database layer using Oracle DB links - some counties are leveraging Delphi business libraries exposed through SOAP Server. • Different EDMS systems exist in the counties, but State SSIS leverages EDMS (IBM FileNet) for state content. • Most of the information sharing (extracts) from MMIS, MAXIS, and PRISM are either daily or monthly. Given feedback from stakeholders, business analysis, current system technical and architecture analysis, and a list of key stakeholders desired outcomes, we are looking for the following deliverables: Alternatives Analysis • List different potential system implementation alternatives, such as COTS, Custom build, enhancing existing system, etc. • Rate/score each alternative utilizing a set of criteria specifically developed based on the business requirements and gap analysis. • See attached Appendix A for a set of needs identified by our previous work. Cost Benefit Analysis • Provide a potential estimated cost for alternatives. • Quantify cost benefits associated with each alternative. • Recommend the most favorable alternatives. 1. Develop final recommendation for Child Welfare Information Systems (CCWIS) implementation. a. Final recommendation may be a hybrid of different alternatives analyzed. b. Final recommendation is specifically tailored for MN DHS to ensure feasible implementation path. c. Recommendation should also include a short-term option as well as a long-term option.  Create Final Recommendation Presentation and present to MN DHS and MNIT@DHS. • Experience working with IT, business, and other stakeholders. • Experience working on State and Federal Government projects that are related to CCWIS (Federal Regulations for Child Welfare Information Systems). Please Respond to pGundraju@encloudservices.com #SSIS #Jobs #Job #IT

[Tip] Upgrade and Migrate SSIS Catalog and SSISDB to a New Server This tip describes different approaches to upgrade and migrate the SSIS catalog to a new server that has a later version of Windows OS and SQL Server. Author: Xiaowei Cao >>> https://lnkd.in/eh9tNmFW #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #integrationservicesupgrade #ssis #ssisdb #upgrade #migration 

Fixing “Target Principal Name is Incorrect” SQL connection error while trying to validate connectivity to the SQL Server #msbts #Csharp #testing

[Tip] Upgrade and Migrate SSIS Catalog and SSISDB to a New Server This tip describes different approaches to upgrade and migrate the SSIS catalog to a new server that has a later version of Windows OS and SQL Server. Author: Xiaowei Cao >>> https://lnkd.in/eM8tXCVw #sql #sqlserver #microsoftsqlserver #mssql #mssqlserver #integrationservicesupgrade #ssis #ssisdb #upgrade #migration 

Today, I want to talk about application integration and how COZYROC has extended SSIS to make it convenient. An ETL platform like SSIS has been designed for very efficient processing of flat, tabular format of data. For application integration you need a system to be able to process hierarchical data layouts, typically encoded in XML or JSON payloads. Systems like Microsoft BizTalk were designed precisely for that requirement, but because of their "one-message-at-time" design, these systems were known to be slow in processing hundreds of thousands of records. The proposed solution for that technical deficiency was to purchase multiple licenses, making the end solution expensive. Is it possible to process hierarchical data in SSIS? On first look, it appears possible. The data flow components in SSIS like XML Source can work with multiple outputs, where each output represents an individual element of the hierarchy. However, in the SSIS data flow there is no straightforward way to identify which children rows (a sequence) belong to which parent row. To solve the challenge, COZYROC came up with the concept of "end of sequence marker" in the form of an empty data flow row appearing in each child output. The empty row is a generic concept, allowing easy grouping of children rows belonging to a parent row. It is consistently implemented in all COZYROC components working with hierarchical data. In addition, we have also implemented a data flow component called Query, very similar to the standard SSIS Lookup component. The Query component can retrieve multiple output rows for a specific input row. With that component, you can retrieve your hierarchical data from a database. In summary, the SSIS platform is designed to process large amounts of data by offering batch-processing capability. By including COZYROC in your toolkit, you can implement any required application integration and enjoy all these performance benefits. Do you like what COZYROC has created? Please repost to help us bring even more magic to SSIS. --- COZYROC is the leading provider of SSIS technology, providing more than 200 additional components. COZYROC's components are completely free for testing and development from Visual Studio. #ETL #SSIS #DataEngineering #SQLServer #COZYROC

Use PL/SQL Developer with FOR UPDATE 😁 #SQL

Implementing PL/SQL exception propagation for handling errors across multiple blocks. #PLSQL #ExceptionHandling #ErrorPropagation

Looking for an SSIS package development expert?  Contact Us Today: (904) 914VSKY (8759) info@vskysolutions.com www.vskysolutions.com  #DataIntegration #SSIS #SQLServer #ETL #DataManagement #WorkflowAutomation #Database #BusinessIntelligence #DataWarehousing #Microsoft #Tech #Development #DataEngineering #Analytics #BigData #IntegrationServices #SQL #VisualStudio #DataTransformation #DataPipeline #Efficiency #DataProcessing #ETLTools #Technology #DataMigration #Coding #Developer #DataAnalytics #Innovation #DigitalTransformation

I believe Kent Bradshaw and I discovered an issue with SSIS 2016 Package Deploy functionality. The behavior we observed affects .Net code contained in SSIS Script Tasks. The workaround is: Use Project Deployment instead of Package Deployment in SSIS 2016. #ssis