O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required