Application Class
SQL Server 2012
Discovers and accesses Package objects. It can also access collections and properties that contain information about the system.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
The Application type exposes the following members.
| Name | Description | |
|---|---|---|
 | CheckSignatureOnLoad | Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package. |
| ComponentStorePath | Returns the path where pipeline components are stored. This property is read-only. |
| ConnectionInfos | Returns a ConnectionInfos collection that contains ConnectionInfo objects. This property is read-only. |
| DataTypeInfos | Returns a DataTypeInfos collection that contains DataTypeInfo objects. This property is read-only. |
| DBProviderInfos | Returns a DBProviderInfos collection that contains DBProviderInfo objects in the application. This property is read-only. |
| DumpDescriptor | Gets or sets the dump descriptor for the application. |
| DumpOnAnyError | Gets or sets whether the application dumps on any error. |
| EnableDump | Gets or sets whether the application enables dumping. |
| ForEachEnumeratorInfos | Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only. |
| LogProviderInfos | Returns a LogProviderInfos collection that contains LogProviderInfo objects. This property is read-only. |
| PackagePassword | Sets the value of the password for the package. This property is write-only. |
| PackageUpgradeOptions | Gets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process. |
| PipelineComponentInfos | Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects. |
| TaskInfos | Returns a TaskInfos collection that contains TaskInfo objects. This property is read-only. |
| UpdateObjects | *** Member deprecated; see Remarks. *** Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found. |
| UpdatePackage | Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found. |
| Name | Description | |
|---|---|---|
| CreateFolderOnDtsServer | Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. |
| CreateFolderOnSqlServer | Creates a folder on the specified instance of SQL Server. |
| CreateSsisServerExecution | Creates SSIS server execution. |
| DataTypeInfoFromDataType | Returns the DataTypeInfo object for the specified data type. |
| Equals | Determines whether two object instances are equal. (Inherited from DtsObject.) |
| ExistsOnDtsServer | Returns a Boolean that indicates whether the specified package already exists on the Integration Services service. |
| ExistsOnSqlServer | Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server. |
| Finalize | (Inherited from Object.) |
| FolderExistsOnDtsServer | Returns a Boolean that indicates whether the specified folder already exists on the file system. |
| FolderExistsOnSqlServer | Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server. |
| GetDtsServerPackageInfos | Gets a PackageInfos collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder. |
| GetDtsServerRoles | Returns an array of Strings that lists the roles available for a folder. |
| GetHashCode | Returns the hash code for this instance. (Inherited from DtsObject.) |
| GetPackageInfos | Gets a PackageInfos collection that contains the packages stored in an instance of SQL Server, within the specified logical folder, by using the server name, user name, and password. |
| GetPackageInfos2 | Infrastructure. Gets a PackageInfos collection that contains the packages stored in an instance of SQL Server, within the specified logical folder, by using the server name, user name, and password. |
| GetPackageRoles | Returns the database roles that have read access and write access to the package. Database roles apply only to packages stored in the SQL Server msdb database. |
| GetRunningPackages | Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only. |
| GetServerInfo | Returns the SQL Server version number of the SQL Server product installed on the target server. |
| GetServerVersionEx | Returns the edition, product level, and other values that indicate the version of SSIS installed. |
| GetType | (Inherited from Object.) |
| LoadFromDtsServer | Loads a package from the specified server. |
| LoadFromSqlServer | Loads a package from SQL Server by specifying the server name, user name, and password. |
| LoadFromSqlServer2 | Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password. |
| LoadPackage(String, IDTSEvents) | Loads a Package from the file system. |
| LoadPackage(String, IDTSEvents, Boolean) | Loads a Package from the file system, and specifies the threading model. |
| MemberwiseClone | (Inherited from Object.) |
| RemoveFolderFromDtsServer | Removes the specified folder from the specified server. |
| RemoveFolderFromSqlServer | Removes the specified folder from the specified instance of SQL Server. |
| RemoveFromDtsServer | Removes a package from the specified server. |
| RemoveFromSqlServer | Removes a package from the specified instance of SQL Server. |
| RenameFolderOnDtsServer | Renames a folder on the specified instance of SQL Server. |
| RenameFolderOnSqlServer | Renames a folder on the specified instance of SQL Server. |
| SaveToDtsServer | Saves a package to the file system. |
| SaveToSqlServer | Saves a package to an instance of SQL Server. |
| SaveToSqlServerAs | Saves a package to an instance of SQL Server with a new name. |
| SaveToXml | Saves the XML definition of a package to a file. |
| SetPackageRoles | Sets the database roles that have read access and write access to the package. Database roles apply only to package stored in the SQL Server msdb database. |
| ToString | (Inherited from Object.) |
| Upgrade | Upgrades one or more Integration Services packages from a specified source location to a specified destination location. |
