On occasion I have the privilege and honor of delivering a full-day precon titled Intelligent Data Integration: SSIS Design Patterns and Biml as part of SQL Saturday events. “Isn’t This The Same Presentation You Delivered Before, Andy?” Yes and no. It has the same title but… I’ve focused on Biml presentations for the past two years. Over the …
Continue reading Intelligent Data Integration, SSIS Design Patterns, and Biml
Category:DILM Suite
The Recording for Designing an SSIS Framework is Now Available
Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can view the webinar for free (although registration is required) here. In the webinar Kent and I discussed the following Data Integration Lifecycle Management Suite products: SSIS Framework Community Edition – free and open source Catalog Reports – …
Continue reading The Recording for Designing an SSIS Framework is Now Available
The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!
The recording for the webinar Biml in the Enterprise Data Integration Lifecycle is now available (registration required). The password for the meeting is BimlRocks. You may be reading this post and thinking, “But Andy, I don’t recall seeing anything about this webinar until just now.” That’s entirely possible. I advertised this webinar in advance, but only to members of the DILM Mailing …
Continue reading The Recording for Biml in the Enterprise Data Integration Lifecycle is Available!
What is the DILM Suite? 2. SSIS Catalog Compare
SSIS Catalog Compare is really two products: SSIS Catalog Compare (GUI – graphical user interface) and CatCompare (CLI – command-line interface). This post will focus on GUI functionality as it’s easier to demonstrate. SSIS Catalog Compare provides the following functionality to enterprise Data Integration Lifecycle Management (DILM): Compares the contents of two SSIS Catalog instances. …
Continue reading What is the DILM Suite? 2. SSIS Catalog Compare
What is the DILM Suite? 1. SSIS Framework Community Edition
Andy Leonard shares solutions for managing enterprise SSIS – the Data Integration Lifecycle Management (DILM) Suite.
Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
This post was originally shared on SQLBlog. You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you’ve been given an ISPAC file, …
Continue reading Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
Why Automate?
This post was originally published at SQLBlog. Because, as Jen Underwood (jenunderwood.com | LinkedIn) states in the Data Driven podcast Jen Underwood on Data Visualization and Automating Data Science: The future of data science is automation. If automation is the future, how do we decide what to automate? We look for the long pole. What’s the long pole in data science? …
Continue reading Why Automate?
Data Wrangling Concepts: Latency and Staleness
This post was originally published at SQLBlog. Latency is the amount of time between data creation and load. Staleness is the amount of time since data in a target was refreshed. In many data integration use cases, a latency or staleness of one day, one week, or even one month is acceptable. Enterprise Data & Analytics helps enterprise data integration teams …
Continue reading Data Wrangling Concepts: Latency and Staleness
Schedule an SSIS Application with SSIS Framework Community Edition
Note: This post was originally posted at SQLBlog. The coolest thing about SSIS Framework Community Edition is it’s free. You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I’m overwhelmed by the number of folks using …
Continue reading Schedule an SSIS Application with SSIS Framework Community Edition
The Heart of SSIS Framework Community Edition-Parent.dtsx
Note: This post was originally posted at SQLBlog. I’m writing about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL Server Agent to schedule the execution …
Continue reading The Heart of SSIS Framework Community Edition-Parent.dtsx