16.2. Application Object Maintenance Operations

The following methods of the Application object allow you to manage a SSIS package in the Windows file system, in the SSIS package store, or within the SQL Server DBMS. In addition, packages can be managed across server instances. Note that methods that contain DtsServer in their names will apply the operation to the SSIS package store, and methods that contain SqlServer in their names will address operations against the SQL Server package store.

16.2.1. Package Maintenance Operations

The Application object exposes the following methods to manage packages in the Windows file system, the SSIS package store, and SQL Server database instance.

  • LoadPackage—Loads a package from the file system

  • LoadFromDtsServer—Loads a package from the specified SSIS package store

  • LoadFromSqlServer—Loads a package to the specified SQL Server instance

  • LoadFromSqlServer2—Loads a package to the specified SQL Server instance by supplying a valid connection object

  • SaveToXML—Saves a package object to the file system with a dtsx file extension

  • SaveToDtsServer—Saves a package to the SSIS package store

  • SaveToSqlServer—Saves a package to the specified SQL Server instance

  • SaveToSqlServerAs—Saves a package as a different name to the specified SQL Server instance

  • RemoveFromDtsServer—Removes a package from the SSIS package store

  • RemoveFromSqlServer—Removes a package from the specified SQL Server instance

  • ExistsOnDtsServer—Indicates whether a specified package already exists ...

Get Professional SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.