Catalog Reports Update

I recently updated the Data Integration Lifecycle Management Suite (DILM Suite) Catalog Reports solution! Here’s a summary of the changes: I re-arranged fields on the Executions Report: I moved the links to the Overview, Messages, and Performance reports to the left in each (execution) row to support easier navigation. I added Previous and Next Execution …
Continue reading Catalog Reports Update

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

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

Adding an SSIS Application to SSIS Framework Community Edition

Note: This post was originally posted at SQLBlog. I’m writing more about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages – called SSIS Applications – in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community Edition, a post that describes using SQL …
Continue reading Adding an SSIS Application to SSIS Framework Community Edition