In this post I will demonstrate how to use the SSIS Catalog to execute and monitor an SSIS project. Manual SSIS Package Execution in the SSIS Catalog To execute an SSIS Package manually using the SSIS Catalog, connect to the SQL Server instance that hosts the Catalog using SQL Server Management Studio (SSMS). Once connected, …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 2
Category:DILM
An Example of Data Integration Lifecycle Management with SSIS, Part 1
In this post I will provide some details about the demo SSIS project. I will then focus on version control and deployment. What DILM Is and Is Not Data Integration Lifecycle Management (DILM) is not about data integration development. DILM is about everything else: Configurations Management Version Management Deployment Execution Although DILM is not about …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 1
An Example of Data Integration Lifecycle Management with SSIS, Part 0
What is Data Integration Lifecycle Management (DILM)? Here’s one way to think about DILM: Data Integration Lifecycle Management (DILM) is applying software Application Lifecycle Management (ALM) best practices to Data Integration development and operations (DevOps), version control, release management, and configuration. I can hear you thinking, “But Andy, why would we apply software best practices …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 0