Application Class

 

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)

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

public ref class Application : DtsObject

NameDescription
System_CAPS_pubmethodApplication()

Initializes a new instance of the Application class.

NameDescription
System_CAPS_pubpropertyCheckSignatureOnLoad

Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.

System_CAPS_pubpropertyComponentStorePath

Returns the path where pipeline components are stored. This property is read-only.

System_CAPS_pubpropertyConnectionInfos

Returns a ConnectionInfos collection that contains ConnectionInfo objects. This property is read-only.

System_CAPS_pubpropertyDataTypeInfos

Returns a DataTypeInfos collection that contains DataTypeInfo objects. This property is read-only.

System_CAPS_pubpropertyDBProviderInfos

Returns a DBProviderInfos collection that contains DBProviderInfo objects in the application. This property is read-only.

System_CAPS_pubpropertyDumpDescriptor

Gets or sets the dump descriptor for the application.

System_CAPS_pubpropertyDumpOnAnyError

Gets or sets whether the application dumps on any error.

System_CAPS_pubpropertyEnableDump

Gets or sets whether the application enables dumping.

System_CAPS_pubpropertyForEachEnumeratorInfos

Returns a ForEachEnumeratorInfos collection that contains ForEachEnumeratorInfo objects. This property is read-only.

System_CAPS_pubpropertyLogProviderInfos

Returns a LogProviderInfos collection that contains LogProviderInfo objects. This property is read-only.

System_CAPS_pubpropertyPackagePassword

Sets the value of the password for the package. This property is write-only.

System_CAPS_pubpropertyPackageUpgradeOptions

Gets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process.

System_CAPS_pubpropertyPipelineComponentInfos

Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects.

System_CAPS_pubpropertyTargetServerVersion

System_CAPS_pubpropertyTaskInfos

Returns a TaskInfos collection that contains TaskInfo objects. This property is read-only.

System_CAPS_pubpropertyUpdateObjects

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

System_CAPS_pubpropertyUpdatePackage

Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.

NameDescription
System_CAPS_pubmethodCreateFolderOnDtsServer(String^, String^, String^)

Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. 

System_CAPS_pubmethodCreateFolderOnSqlServer(String^, String^, String^, String^, String^)

Creates a folder on the specified instance of SQL Server.

System_CAPS_pubmethodCreateSsisServerExecution(String^, String^, String^, Boolean)

Creates SSIS server execution.

System_CAPS_pubmethodDataTypeInfoFromDataType(DataType)

Returns the DataTypeInfo object for the specified data type.

System_CAPS_pubmethodEquals(Object^)

Determines whether two object instances are equal.(Inherited from DtsObject.)

System_CAPS_pubmethodExistsOnDtsServer(String^, String^)

Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.

System_CAPS_pubmethodExistsOnSqlServer(String^, String^, String^, String^)

Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodFolderExistsOnDtsServer(String^, String^)

Returns a Boolean that indicates whether the specified folder already exists on the file system.

System_CAPS_pubmethodFolderExistsOnSqlServer(String^, String^, String^, String^)

Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.

System_CAPS_pubmethodGetDtsServerPackageInfos(String^, String^)

Gets a PackageInfos collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder.

System_CAPS_pubmethodGetDtsServerRoles(String^, String^)

Returns an array of Strings that lists the roles available for a folder.

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this instance.(Inherited from DtsObject.)

System_CAPS_pubmethodGetPackageInfos(String^, String^, String^, String^)

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.

System_CAPS_pubmethodGetPackageInfos2(String^, Object^)

This API supports the product infrastructure and is not intended to be used directly from your code. 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.

System_CAPS_pubmethodGetPackageRoles(String^, String^, String^%, String^%)

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.

System_CAPS_pubmethodGetRunningPackages(String^)

Returns a RunningPackages collection that contains RunningPackage objects. This property is read-only.

System_CAPS_pubmethodGetServerInfo(String^, String^%)

Returns the SQL Server version number of the SQL Server product installed on the target server. 

System_CAPS_pubmethodGetServerVersionEx(String^, Int32%, DTSProductLevel%, String^%, String^%)

Returns the edition, product level, and other values that indicate the version of SSIS installed.

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodLoadFromDtsServer(String^, String^, IDTSEvents^)

Loads a package from the specified server.

System_CAPS_pubmethodLoadFromSqlServer(String^, String^, String^, String^, IDTSEvents^)

Loads a package from SQL Server by specifying the server name, user name, and password.

System_CAPS_pubmethodLoadFromSqlServer2(String^, Object^, IDTSEvents^)

This API supports the product infrastructure and is not intended to be used directly from your code. Loads a package from SQL Server by specifying the server name, user name, and password.

System_CAPS_pubmethodLoadPackage(String^, IDTSEvents^)

Loads a Package from the file system.

System_CAPS_pubmethodLoadPackage(String^, IDTSEvents^, Boolean)

Loads a Package from the file system, and specifies the threading model.

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodRemoveFolderFromDtsServer(String^, String^)

Removes the specified folder from the specified server.

System_CAPS_pubmethodRemoveFolderFromSqlServer(String^, String^, String^, String^)

Removes the specified folder from the specified instance of SQL Server.

System_CAPS_pubmethodRemoveFromDtsServer(String^, String^)

Removes a package from the specified server.

System_CAPS_pubmethodRemoveFromSqlServer(String^, String^, String^, String^)

Removes a package from the specified instance of SQL Server.

System_CAPS_pubmethodRenameFolderOnDtsServer(String^, String^, String^, String^)

Renames a folder on the specified instance of SQL Server.

System_CAPS_pubmethodRenameFolderOnSqlServer(String^, String^, String^, String^, String^, String^)

Renames a folder on the specified instance of SQL Server.

System_CAPS_pubmethodSaveAndUpdateVersionToXml(String^, Package^, DTSTargetServerVersion, IDTSEvents^)

System_CAPS_pubmethodSaveToDtsServer(Package^, IDTSEvents^, String^, String^)

Saves a package to the file system.

System_CAPS_pubmethodSaveToSqlServer(Package^, IDTSEvents^, String^, String^, String^)

Saves a package to an instance of SQL Server.

System_CAPS_pubmethodSaveToSqlServerAs(Package^, IDTSEvents^, String^, String^, String^, String^)

Saves a package to an instance of SQL Server with a new name.

System_CAPS_pubmethodSaveToXml(String^, Package^, IDTSEvents^)

Saves the XML definition of a package to a file.

System_CAPS_pubmethodSetPackageRoles(String^, String^, String^, String^)

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.

System_CAPS_pubmethodToString()

(Inherited from Object.)

System_CAPS_pubmethodUpgrade(IEnumerable<UpgradePackageInfo^>^, StorageInfo^, StorageInfo^, BatchUpgradeOptions^, IDTSEvents^)

Upgrades one or more Integration Services packages from a specified source location to a specified destination location.

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.

Return to top
Show: