SSISDB was huge, and the biggest table was catalog.execution_component_phases. Here is what fills it, like retention period and logging level.
Zip Files in SSIS With a Script Task and ZipFile
To zip files in SSIS you don’t need a third-party tool. This guest post by Kevin Hazzard shows how a Script Task and the .NET ZipFile class zip a whole folder in a few lines of C#, and which errors to expect.
SQL SERVER – Data Lineage Tracking in ETL Processes – Notes from the Field #124
Tim Mitchell answers the question every ETL developer hears, ‘Where did this data come from?’, and shows how to add data lineage tracking to ETL processes.
SQL SERVER – SSIS – Get Started with the For Loop Container – Notes from the Field #113
In Notes from the Field #113, Tim Mitchell shows how to get started with the SSIS For Loop Container to control how many times your ETL logic runs.
SQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
Tim Mitchell shows a handy but overlooked feature: project versions in the SSIS catalog, which keep earlier deployments you can browse in SSMS.
SQL SERVER – A Stored Procedure for Executing SSIS Packages in the SSIS Catalog – Notes from the Field #092
SSIS expert Andy Leonard shares a stored procedure for executing SSIS packages in the SSIS Catalog, from the book SSIS Design Patterns. Notes from the Field #092.
SQL SERVER – Using Project Connections in SSIS – Notes from the Field #088
Connection managers are the gateway for most SSIS reads and writes. In Notes from the Field #088, Tim Mitchell explains how to use Project Connections in SSIS.