Application Application Application Class

Definition

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

public ref class Application : Microsoft::SqlServer::Dts::Runtime::DtsObject
public class Application : Microsoft.SqlServer.Dts.Runtime.DtsObject
Public Class Application
Inherits DtsObject
Inheritance
ApplicationApplicationApplication

Remarks

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

Constructors

Application() Application() Application()

Initializes a new instance of the Application class.

Properties

CheckSignatureOnLoad CheckSignatureOnLoad CheckSignatureOnLoad

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

ComponentStorePath ComponentStorePath ComponentStorePath

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

ConnectionInfos ConnectionInfos ConnectionInfos

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

DataTypeInfos DataTypeInfos DataTypeInfos

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

DBProviderInfos DBProviderInfos DBProviderInfos

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

DumpDescriptor DumpDescriptor DumpDescriptor

Gets or sets the dump descriptor for the application.

DumpOnAnyError DumpOnAnyError DumpOnAnyError

Gets or sets whether the application dumps on any error.

EnableDump EnableDump EnableDump

Gets or sets whether the application enables dumping.

ForEachEnumeratorInfos ForEachEnumeratorInfos ForEachEnumeratorInfos

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

LogProviderInfos LogProviderInfos LogProviderInfos

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

PackagePassword PackagePassword PackagePassword

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

PackageUpgradeOptions PackageUpgradeOptions 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 PipelineComponentInfos PipelineComponentInfos

Returns a PipelineComponentInfos collection that contains PipelineComponentInfo objects.

TargetServerVersion TargetServerVersion TargetServerVersion
TaskInfos TaskInfos TaskInfos

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

UpdateObjects UpdateObjects 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 UpdatePackage UpdatePackage

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

Methods

CreateFolderOnDtsServer(String, String, String) CreateFolderOnDtsServer(String, String, String) CreateFolderOnDtsServer(String, String, String)

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

CreateFolderOnSqlServer(String, String, String, String, String) CreateFolderOnSqlServer(String, String, String, String, String) CreateFolderOnSqlServer(String, String, String, String, String)

Creates a folder on the specified instance of SQL Server.

CreateSsisServerExecution(String, String, String, Boolean) CreateSsisServerExecution(String, String, String, Boolean) CreateSsisServerExecution(String, String, String, Boolean)

Creates SSIS server execution.

DataTypeInfoFromDataType(DataType) DataTypeInfoFromDataType(DataType) DataTypeInfoFromDataType(DataType)

Returns the DataTypeInfo object for the specified data type.

Equals(Object) Equals(Object) Equals(Object)

Determines whether two object instances are equal.

(Inherited from DtsObject)
ExistsOnDtsServer(String, String) ExistsOnDtsServer(String, String) ExistsOnDtsServer(String, String)

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

ExistsOnSqlServer(String, String, String, String) ExistsOnSqlServer(String, String, String, String) ExistsOnSqlServer(String, String, String, String)

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

FolderExistsOnDtsServer(String, String) FolderExistsOnDtsServer(String, String) FolderExistsOnDtsServer(String, String)

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

FolderExistsOnSqlServer(String, String, String, String) FolderExistsOnSqlServer(String, String, String, String) FolderExistsOnSqlServer(String, String, String, String)

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

GetDtsServerPackageInfos(String, String) GetDtsServerPackageInfos(String, String) GetDtsServerPackageInfos(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.

GetDtsServerRoles(String, String) GetDtsServerRoles(String, String) GetDtsServerRoles(String, String)

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

GetHashCode() GetHashCode() GetHashCode()

Returns the hash code for this instance.

(Inherited from DtsObject)
GetPackageInfos(String, String, String, String) GetPackageInfos(String, String, String, String) GetPackageInfos(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.

GetPackageInfos2(String, Object) GetPackageInfos2(String, Object) GetPackageInfos2(String, Object)

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(String, String, String, String) GetPackageRoles(String, String, String, String) GetPackageRoles(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.

GetRunningPackages(String) GetRunningPackages(String) GetRunningPackages(String)

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

GetServerInfo(String, String) GetServerInfo(String, String) GetServerInfo(String, String)

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

GetServerVersionEx(String, Int32, DTSProductLevel, String, String) GetServerVersionEx(String, Int32, DTSProductLevel, String, String) GetServerVersionEx(String, Int32, DTSProductLevel, String, String)

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

LoadFromDtsServer(String, String, IDTSEvents) LoadFromDtsServer(String, String, IDTSEvents) LoadFromDtsServer(String, String, IDTSEvents)

Loads a package from the specified server.

LoadFromSqlServer(String, String, String, String, IDTSEvents) LoadFromSqlServer(String, String, String, String, IDTSEvents) LoadFromSqlServer(String, String, String, String, IDTSEvents)

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

LoadFromSqlServer2(String, Object, IDTSEvents) LoadFromSqlServer2(String, Object, IDTSEvents) LoadFromSqlServer2(String, Object, IDTSEvents)

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

LoadPackage(String, IDTSEvents) LoadPackage(String, IDTSEvents) LoadPackage(String, IDTSEvents)

Loads a Package from the file system.

LoadPackage(String, IDTSEvents, Boolean) LoadPackage(String, IDTSEvents, Boolean) LoadPackage(String, IDTSEvents, Boolean)

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

RemoveFolderFromDtsServer(String, String) RemoveFolderFromDtsServer(String, String) RemoveFolderFromDtsServer(String, String)

Removes the specified folder from the specified server.

RemoveFolderFromSqlServer(String, String, String, String) RemoveFolderFromSqlServer(String, String, String, String) RemoveFolderFromSqlServer(String, String, String, String)

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

RemoveFromDtsServer(String, String) RemoveFromDtsServer(String, String) RemoveFromDtsServer(String, String)

Removes a package from the specified server.

RemoveFromSqlServer(String, String, String, String) RemoveFromSqlServer(String, String, String, String) RemoveFromSqlServer(String, String, String, String)

Removes a package from the specified instance of SQL Server.

RenameFolderOnDtsServer(String, String, String, String) RenameFolderOnDtsServer(String, String, String, String) RenameFolderOnDtsServer(String, String, String, String)

Renames a folder on the specified instance of SQL Server.

RenameFolderOnSqlServer(String, String, String, String, String, String) RenameFolderOnSqlServer(String, String, String, String, String, String) RenameFolderOnSqlServer(String, String, String, String, String, String)

Renames a folder on the specified instance of SQL Server.

SaveAndUpdateVersionToXml(String, Package, DTSTargetServerVersion, IDTSEvents) SaveAndUpdateVersionToXml(String, Package, DTSTargetServerVersion, IDTSEvents) SaveAndUpdateVersionToXml(String, Package, DTSTargetServerVersion, IDTSEvents)
SaveToDtsServer(Package, IDTSEvents, String, String) SaveToDtsServer(Package, IDTSEvents, String, String) SaveToDtsServer(Package, IDTSEvents, String, String)

Saves a package to the file system.

SaveToSqlServer(Package, IDTSEvents, String, String, String) SaveToSqlServer(Package, IDTSEvents, String, String, String) SaveToSqlServer(Package, IDTSEvents, String, String, String)

Saves a package to an instance of SQL Server.

SaveToSqlServerAs(Package, IDTSEvents, String, String, String, String) SaveToSqlServerAs(Package, IDTSEvents, String, String, String, String) SaveToSqlServerAs(Package, IDTSEvents, String, String, String, String)

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

SaveToXml(String, Package, IDTSEvents) SaveToXml(String, Package, IDTSEvents) SaveToXml(String, Package, IDTSEvents)

Saves the XML definition of a package to a file.

SetPackageRoles(String, String, String, String) SetPackageRoles(String, String, String, String) SetPackageRoles(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.

Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents) Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents) Upgrade(IEnumerable<UpgradePackageInfo>, StorageInfo, StorageInfo, BatchUpgradeOptions, IDTSEvents)

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

Applies to