Export (0) Print
Expand All

Saving a Package Programmatically

New: 14 April 2006

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.90).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".

Community Additions

ADD
Show:
© 2014 Microsoft