Running and Managing Packages Programmatically
If you need to manage and run Integration Services packages programmatically, you have a range of options:
Load and run an existing package without change.
Load an existing package, reconfigure the package (for example, for a different data source), and then run the package.
Create a new package, add and configure components object by object and property by property, save the package, and then run the package.
You can load and run an existing package from a client application by writing only a few lines of code.
This section describes and demonstrates how to run an existing package programmatically and how to access the output of the data flow from other applications. As an advanced programming option, you can programmatically create an Integration Services package line-by-line as described in the topic, Building Packages Programmatically.
This section also discusses other administrative tasks that you can perform programmatically to manage stored packages, running packages, and package roles.