O'Reilly logo

Professional SQL Server™ 2005 Integration Services by Mike Murphy, Haidong Ji, Jason Gerard, Erik Veerman, Andy Leonard, Kathi Kellenberger, Douglas Hinson, Darren Green, Allan Mitchell, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required