| title | Saving a Package Programmatically | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 04/27/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | integration-services | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| ms.assetid | 4204f817-d5df-475a-9338-d7f01305d566 | ||
| author | janinezhang | ||
| ms.author | janinez | ||
| manager | craigg |
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 xref:Microsoft.SqlServer.Dts.Runtime namespace with a using or Imports statement.
To save a package programmatically, call one of the following methods of the [!INCLUDEssISnoversion] xref:Microsoft.SqlServer.Dts.Runtime.Application class:
| Storage Location | Method to Call |
|---|---|
| File | xref:Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml%2A |
| SSIS Package Store | xref:Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer%2A |
| [!INCLUDEssNoVersion] | xref:Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer%2A or xref:Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs%2A |
Important
The methods of the xref:Microsoft.SqlServer.Dts.Runtime.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 [!INCLUDEssISnoversion] page on MSDN:
Visit the Integration Services page on MSDN
For automatic notification of these updates, subscribe to the RSS feeds available on the page.