The Application object is the core class that exposes methods used to connect to and interface with an SSIS service instance for pre-SQL 2012 instances of SQL Server or when the deployment model of your SSIS project is set to use the package deployment model. The following are typical management operations that can be performed using this class:
Load, save, and delete SSIS packages on the Windows files system, SQL Server, or Integration Services repository
Construct and execute packages either from a storage facility or in memory
Add, remove, and rename folders in SQL Server or Integration Services repository folders
Control package permissions stored within a SQL Server
Obtain state information and status regarding the execution of packages in SQL Server or the SSIS package repository
You are currently reading a PREVIEW of this book.
Get instant access to over
$1 million worth of books and videos.