© Andy Leonard 2021
A. LeonardBuilding Custom Tasks for SQL Server Integration Serviceshttps://doi.org/10.1007/978-1-4842-6482-9_23

23. Using the Execute Catalog Package Task in an SSIS Framework

Andy Leonard1  
(1)
Farmville, VA, USA
 

In the book titled SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory (amazon.com/Server-Data-Automation-Through-Frameworks/dp/1484262123), Kent Bradshaw and I describe and demonstrate data frameworks that execute stored procedures and SSIS packages. Kent shares a metadata-driven stored procedure-based framework that executes other stored procedures and records execution report data. I share an SSIS framework that executes SSIS packages stored in ...

Get Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.