SSIS Version 15.0 Script Error

There I was… Delivering ExpertSSIS training with Brent Ozar Unlimited (we’re going to present another ExpertSSIS class – stay tuned for more information). I scheduled the execution of an SSIS package that contains a Script Task via SQL Agent, executed the job, and boom: “Excellent teaching moment,” I thought as I opened SSIS Catalog Overview and …
Continue reading SSIS Version 15.0 Script Error

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

The Recording for Enterprise SSIS, Biml, and DILM is Available!

Kent and I had an awesome time delivering Enterprise SSIS, Biml, and DILM! I think it shows. You can check out the recording here (registration required). You can get the tools and utilities we demonstrated at DILM Suite – most are free and some are even open-source! You can grab the latest release of BimlExpress from Varigence! :{>

An Example of Data Integration Lifecycle Management with SSIS, Part 4

In this post I will demonstrate advanced options for executing SSIS packages in the SSIS Catalog. I’ll also demonstrate SSIS Catalog Browser, SSIS Framework Community Edition, Framework Browser, and Catalog Reports – free utilities and solutions from DILM Suite that may help as you implement your enterprise Data Integration Lifecycle Management (DILM). The Problem I …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 4

An Example of Data Integration Lifecycle Management with SSIS, Part 3

In this post I will demonstrate how to use SSIS Catalog Environments, References,  and Reference Mappings to override SSIS parameter values at execution time. There three sources of SSIS parameter values: Design-time defaults – these are the parameter values developers use when building the SSIS project and packages. SSIS Catalog Literal overrides – as part …
Continue reading An Example of Data Integration Lifecycle Management with SSIS, Part 3