Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Application Class

Discovers and accesses Package objects. It can also access collections and properties that contain information about the system.

System::Object
  Microsoft.SqlServer.Dts.Runtime::DtsObject
    Microsoft.SqlServer.Dts.Runtime::Application

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
public ref class Application : public DtsObject

The Application type exposes the following members.

  NameDescription
Public methodApplicationInitializes a new instance of the Application class.
Top
  NameDescription
Public propertyCheckSignatureOnLoadGets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
Public propertyComponentStorePathReturns the path where pipeline components are stored. This property is read-only.
Public propertyConnectionInfosReturns a ConnectionInfos collection that contains ConnectionInfo objects. This property is read-only.
Public propertyDataTypeInfosReturns a DataTypeInfos collection that contains DataTypeInfo objects. This property is read-only.
Public propertyDBProviderInfosReturns a DBProviderInfos collection that contains DBProviderInfo objects in the application. This property is read-only.
Public propertyDumpDescriptorGets or sets the dump descriptor for the application.
Public propertyDumpOnAnyErrorGets or sets whether the application dumps on any error.
Public propertyEnableDumpGets or sets whether the application enables dumping.
Public propertyForEachEnumeratorInfosReturns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only.
Public propertyLogProviderInfosReturns a LogProviderInfos collection that contains LogProviderInfo objects. This property is read-only.
Public propertyPackagePasswordSets the value of the password for the package. This property is write-only.
Public propertyPackageUpgradeOptionsGets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process.
Public propertyPipelineComponentInfosReturns a PipelineComponentInfos collection that contains PipelineComponentInfo objects.
Public propertyTaskInfosReturns a TaskInfos collection that contains TaskInfo objects. This property is read-only.
Public propertyUpdateObjects*** 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.
Public propertyUpdatePackageGets or sets a Boolean that indicates whether packages can be updated when an updated version is found.
Top
  NameDescription
Public methodCreateFolderOnDtsServerCreates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. 
Public methodCreateFolderOnSqlServerCreates a folder on the specified instance of SQL Server.
Public methodCreateSsisServerExecutionCreates SSIS server execution.
Public methodDataTypeInfoFromDataTypeReturns the DataTypeInfo object for the specified data type.
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Public methodExistsOnDtsServerReturns a Boolean that indicates whether the specified package already exists on the Integration Services service.
Public methodExistsOnSqlServerReturns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
Protected methodFinalize (Inherited from Object.)
Public methodFolderExistsOnDtsServerReturns a Boolean that indicates whether the specified folder already exists on the file system.
Public methodFolderExistsOnSqlServerReturns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
Public methodGetDtsServerPackageInfosGets a PackageInfos collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder.
Public methodGetDtsServerRolesReturns an array of Strings that lists the roles available for a folder.
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetPackageInfosGets 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.
Public methodGetPackageInfos2Infrastructure. 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.
Public methodGetPackageRolesReturns 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.
Public methodGetRunningPackagesReturns a RunningPackages collection that contains RunningPackage objects. This property is read-only.
Public methodGetServerInfoReturns the SQL Server version number of the SQL Server product installed on the target server. 
Public methodGetServerVersionExReturns the edition, product level, and other values that indicate the version of SSIS installed.
Public methodGetType (Inherited from Object.)
Public methodLoadFromDtsServerLoads a package from the specified server.
Public methodLoadFromSqlServerLoads a package from SQL Server by specifying the server name, user name, and password.
Public methodLoadFromSqlServer2Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password.
Public methodLoadPackage(String, IDTSEvents)Loads a Package from the file system.
Public methodLoadPackage(String, IDTSEvents, Boolean)Loads a Package from the file system, and specifies the threading model.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRemoveFolderFromDtsServerRemoves the specified folder from the specified server.
Public methodRemoveFolderFromSqlServerRemoves the specified folder from the specified instance of SQL Server.
Public methodRemoveFromDtsServerRemoves a package from the specified server.
Public methodRemoveFromSqlServerRemoves a package from the specified instance of SQL Server.
Public methodRenameFolderOnDtsServerRenames a folder on the specified instance of SQL Server.
Public methodRenameFolderOnSqlServerRenames a folder on the specified instance of SQL Server.
Public methodSaveToDtsServerSaves a package to the file system.
Public methodSaveToSqlServerSaves a package to an instance of SQL Server.
Public methodSaveToSqlServerAsSaves a package to an instance of SQL Server with a new name.
Public methodSaveToXmlSaves the XML definition of a package to a file.
Public methodSetPackageRolesSets 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.
Public methodToString (Inherited from Object.)
Public methodUpgradeUpgrades one or more Integration Services packages from a specified source location to a specified destination location.
Top

The Application object is a system discovery and package access mechanism.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.