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
Author:Andy Leonard
Introducing astreams
For months, I’ve received pings about a screenshot I posted on social media a year or so ago. Plus I needed to wind down. You real runners will know what I mean: You know how you feel after you’ve covered some distance (for you)? You need to walk around for a bit, you can’t just …
Continue reading Introducing astreams
The Recording for SSIS Catalog Management is Available
The recording for the Enterprise Data & Analytics webinar titled “SSIS Catalog Management” is now available (registration is required). In the SSIS Academy: Using the SSIS Catalog series, Kent and I walked through the SSIS Catalog functionality built into SQL Server Management Studio (SSMS). This webinar picks up where SSIS Academy: Using the SSIS Catalog, …
Continue reading The Recording for SSIS Catalog Management is Available
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
Announcing SSIS Catalog Compare and CatCompare Version 2
I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare. If you’re interested in learning more about the functionality provided by the products you can …
Continue reading Announcing SSIS Catalog Compare and CatCompare Version 2
Save Time and Improve SSIS Quality with Biml, A Free Webinar
Join me at 1:00 PM EST 31 Jan 2017 for Save Time and Improve SSIS Quality with Biml, another free webinar from Enterprise Data & Analytics! “Save Time and Improve SSIS Quality with Biml” introduces Business Intelligence Markup Language (Biml) to SSIS developers, DBAs, sysadmins, and others who want to learn more about automating SSIS …
Continue reading Save Time and Improve SSIS Quality with Biml, A Free Webinar
Presenting “Using Biml as an SSIS Design Patterns Engine” at the (605) SQL Server User Group 10 Jan
I am honored to present – albeit remotely – Using Biml as an SSIS Design Patterns Engine to the (605) SQL Server User Group in Sioux Falls, SD Tuesday 10 Jan 2017! Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new …
Continue reading Presenting “Using Biml as an SSIS Design Patterns Engine” at the (605) SQL Server User Group 10 Jan
Free Webinar–Advanced SSIS Execution–24 Jan 2017
Join Enterprise Data & Analytics for Advanced SSIS Execution, a free webinar starting at 1:00 PM EST 24 Jan 2017! Kent and I demonstrated how to use the SSIS Catalog in the SSIS Academy series (see links to the recordings in the Learn More section). In this webinar, we share several ways to execute SSIS …
Continue reading Free Webinar–Advanced SSIS Execution–24 Jan 2017
Free Webinar–SSIS Catalog Management–10 Jan 2017
Join Enterprise Data & Analytics for SSIS Catalog Management, a free webinar starting at 1:00 PM EST 10 Jan 2017! Kent and I demonstrated how to use the SSIS Catalog in the SSIS Academy series (see links to the recordings in the Learn More section). In this webinar, we share best practices, tips, and tools …
Continue reading Free Webinar–SSIS Catalog Management–10 Jan 2017
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
