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

Overview of SSIS Integration in Custom Applications

So far, you’ve learned how you can extend SSIS through custom object development. But sometimes you might want to extend your custom application by integrating SSIS functionality directly into it, rather than extending SSIS itself.

In this section, we’ll answer the following questions:

  • How can you integrate SSIS package functionality into custom applications so that you can execute packages from inside of those applications?

  • How do you enable your application to consume the data that SSIS produces as a result of a data flow task?

Before we explain how you can do these powerful things, we should emphasize two vital concepts:

  • A package runs on the same computer as the program that launches it. Even ...

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