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