Running and Managing Packages Programmatically

If you need manage and execute Integration Services packages outside the development environment, you can manipulate packages programmatically. In this approach, you have a range of options:

  • Load and execute an existing package without modification.

  • Load an existing package, reconfigure it (for example, for a different data source), and execute it.

  • Create a new package, add and configure components object by object and property by property, save it, and execute it.

You can load and execute an existing package from a client application by writing only a few lines of code.

This section describes and demonstrates how to execute 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 Building Packages Programmatically.

This section also discusses other administrative tasks that you can perform programmatically to manage stored packages, running packages, and package roles.

In This Section


Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.