Managing Packages and Folders Programmatically

Article
12/15/2008

Nouveau : 14 avril 2006

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.

In This Topic

Determining whether a package or folder exists
Managing packages and folders
- Removing a package
- Creating a folder
- Removing a folder
- Renaming a folder

For information about enumerating available packages, see Enumerating Available Packages Programmatically. For information about loading and running saved packages programmatically, see Loading and Running a Local Package Programmatically and Loading and Running a Remote Package Programmatically.

All the methods discussed in this topic 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.

Important :
The methods of the Application class for working with the SSIS Package Store support only ".", localhost, or the server name for the local server. You cannot use "(local)".

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