Using Integration Services with Other Applications
If you need to create packages dynamically, or to manage and execute Integration Services packages outside the development environment, you can manipulate packages programmatically. You can use the Integration Services object model to write code that creates and configures a new package, or loads and executes a saved package, in any managed programming language. You can also load the output of a package's data flow directly from memory into your custom application.
For more information, see Building Packages Programmatically.
Using the extensive Integration Services object model, you can:
Build and configure packages. Create a new package one task and component at a time, and then save it to your preferred storage location. For more information, see Building Packages Programmatically.
Enumerate saved packages. Loop through existing packages to check whether an individual package or folder exists. For more information, see Enumerating Available Packages Programmatically.
Load and execute. Open a saved package, optionally reconfigure it, and then run the package. You can also load the output of the package's data flow into your application directly from memory. For more information, see Running an SSIS Package Programmatically on the Local Computer, Running an SSIS Package Programmatically on a Remote Computer, and Loading the Output of a Package into Another Program.
Managed saved packages and folders. Remove or add packages, and create, rename, or remove folders. For more information, see Managing Packages and Folders Programmatically.