| title | Saving a Package Programmatically | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | integration-services | ||
| ms.reviewer | |||
| ms.technology | integration-services | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| ms.assetid | 4204f817-d5df-475a-9338-d7f01305d566 | ||
| author | chugugrace | ||
| ms.author | chugu |
[!INCLUDEssis-appliesto]
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".