Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Development
Developer's Guide
 Saving a Package Programmatically
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
Saving a Package Programmatically

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.

To save a package programmatically, call one of the following methods of the Integration Services Application class:

Storage Location Method to Call

File

SaveToXml

SSIS Package Store

SaveToDtsServer

SQL Server

SaveToSqlServer

or

SaveToSqlServerAs

ms403347.note(en-us,SQL.100).gifImportant:
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".

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.

Other Resources

Saving Packages

Help and Information

Getting SQL Server 2008 Assistance
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker