O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

The Integration Services Object Model and Components

Although the tools included with SSIS provide a great deal of out-of-the-box functionality, on occasion these tools do not provide everything that SSIS developers need. For these situations, SSIS provides a complete managed API that can be used to create, modify, and execute packages. The .NET API exposes the SSIS runtime, with classes for manipulating tasks, containers, and precedence constraints, and the SSIS data flow pipeline, with classes for manipulating sources, transformations, and destinations.

Through the SSIS API, developers can also build their own custom tasks, transformations, data sources and destinations, connection managers, and log providers. SSIS also includes a Script task ...

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