After building a new package programmatically, or modifying an existing one, you usually want to save your changes.
All of the methods used in this topic to save packages require a reference to the Microsoft.SqlServer.ManagedDTS assembly. After you add the reference in a new project, import the Microsoft.SqlServer.Dts.Runtime namespace with a using or Imports statement.
Saving a Package Programmatically
To save a package programmatically, call one of the following methods of the Integration Services Application class:
Important: |
|---|
|
The methods of the Application class for working with the SSIS Package Store only support "." or the server name for the local server. You cannot use "(local)" or "localhost".
|
-
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.
|
Other Resources
Saving Packages
Help and Information
Getting SQL Server 2008 Assistance