Chapter 19. Automating SSIS

Introduction to SSIS Automation

The primary ways of using SSIS involve manual interaction; for example, creating packages in SQL Server Data Tools, running packages using DTEXEC and SQL Server Management Studio, or managing parameters in the SSIS Catalog. There are many scenarios where an automated approach is preferable. SSIS was designed with this in mind, and therefore any interaction with the product done through the SSIS tools is also possible through the SSIS application programming interfaces (APIs) and object model. Any time you find yourself doing the same SSIS tasks multiple ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.