Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Running an SSIS Package Programmatically on the Local Computer

Describes how to start and run an existing package, without change, from a client application on the local computer.

Running an SSIS Package Programmatically on a Remote Computer

Describes how a client application on the local computer can start and run an existing package from the remote computer where the package is stored.

Loading the Output of a Package into Another Program

Describes how to run a package on the local computer, and load the output of the data flow into a client application by using the DataReader destination and the DtsClient namespace.

Enumerating Available Packages Programmatically

Describes how to discover available packages that are managed by the Integration Services service.

Managing Packages and Folders Programmatically

Describes how to create, rename, and delete both packages and folders.

Managing Running Packages Programmatically

Describes how to list packages that are currently running, examine their properties, and stop a running package.

Managing Package Roles Programmatically

Describes how to get or set information about the roles assigned to a package or a folder.

SSIS Error and Message Reference

Lists the predefined Integration Services error codes with their symbolic names and descriptions.

Extending Packages with Scripting

Discusses how to extend the control flow by using the Script task, and how to extend the data flow by using the Script component.

Extending Packages with Custom Objects

Discusses how to create program custom tasks, data flow components, and other package objects for use in multiple packages.

Building Packages Programmatically

Discusses how to create, configure, and save Integration Services packages programmatically.

Integration Services Samples

Lists and describes the Integration Services programming samples that are available as an optional installation component.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft