Managing Packages and Folders Programmatically

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

As you work programmatically with Integration Services packages, you may want to determine whether an individual package or folder exists, or to manage the folders in which packages are stored. The Application class of the Microsoft.SqlServer.Dts.Runtime namespace provides a variety of methods to satisfy these requirements.

Determining Whether a Package or Folder Exists

To determine programmatically whether a saved package exists, call one of the following methods before attempting to load and run the package:

Storage Location	Method to Call
SSIS Package Store	ExistsOnDtsServer
SQL Server	ExistsOnSqlServer

To determine programmatically whether a folder exists, call one of the following methods before attempting to list the packages stored in the folder, :

Storage Location	Method to Call
SSIS Package Store	FolderExistsOnDtsServer
SQL Server	FolderExistsOnSqlServer

Back to top

Managing Packages and Folders

The Application class of the Microsoft.SqlServer.Dts.Runtime namespace provides additional methods for managing packages and the folders in which they are stored.

Removing a Package

To remove a saved package programmatically, call one of the following methods:

Storage Location	Method to Call
SSIS Package Store	RemoveFromDtsServer
SQL Server	RemoveFromSqlServer

Back to top

Creating a Folder

To create a storage folder programmatically, call one of the following methods:

Storage Location	Method to Call
SSIS Package Store	CreateFolderOnDtsServer
SQL Server	CreateFolderOnSqlServer

Back to top

Removing a Folder

To remove a storage folder programmatically, call one of the following methods:

Storage Location	Method to Call
SSIS Package Store	RemoveFolderFromDtsServer
SQL Server	RemoveFolderFromSqlServer

Back to top

Renaming a Folder

To rename a storage folder programmatically, call one of the following methods:

Storage Location	Method to Call
SSIS Package Store	RenameFolderOnDtsServer
SQL Server	RenameFolderOnSqlServer

Back to top

See Also

Package Management (SSIS Service)
Enumerating Available Packages Programmatically