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