Resources

Source Code

You can download the T-SQL source code from the book in a single archive file here.

Links

Chapter 3: Deployment

• Deploy a project using PowerShell

Chapter 4: Execution

• ETL atomicity

Chapter 6: Execution Logging

• Execution status list
• Custom logging levels
• Data taps

Chapter 7: Enterprise Management and Administration

• Custom purge script for the SSIS catalog
• Set up Always On for the SSIS catalog
• Restore the SSIS catalog

Other Resources

To address the limitations of the built-in SSIS catalog reports, I have created an SSIS catalog dashboard for easy reporting using SSRS.

I also recorded a brief video introduction to the SSIS catalog a few years ago.