Share via


IDTSApplication100 Interface

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

Provides properties and methods that are used to discover and access Package objects.

Namespace:  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

Syntax

'Declaration
<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")> _
Public Interface IDTSApplication100
'Usage
Dim instance As IDTSApplication100
[GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")]
public interface IDTSApplication100
[GuidAttribute(L"E8102616-3E24-4827-85B2-4897E71B598B")]
public interface class IDTSApplication100
[<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")>]
type IDTSApplication100 =  interface end
public interface IDTSApplication100

The IDTSApplication100 type exposes the following members.

Properties

  Name Description
Public property CheckSignatureOnLoad Infrastructure. Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
Public property ComponentStorePath Infrastructure. Returns the path where pipeline components are stored. This property is read-only.
Public property ConnectionInfos Infrastructure. Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only.
Public property DataTypeInfos Infrastructure. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only.
Public property DBProviderInfos Infrastructure. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only.
Public property ForEachEnumeratorInfos Infrastructure. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only.
Public property LogProviderInfos Infrastructure. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only.
Public property PackagePassword Infrastructure. Sets the value of the password for the package. This property is write-only.
Public property PackageUpgradeOptions Infrastructure. Gets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process.
Public property PipelineComponentInfos Infrastructure. Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects.
Public property ProjectPassword Infrastructure. Sets the value of the password for the project. This property is write-only.
Public property TaskInfos Infrastructure. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only.
Public property UpdateObjects Infrastructure. Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found.
Public property UpdatePackage Infrastructure. Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.

Top

Methods

  Name Description
Public method CloseProject Infrastructure. Closes a specified project.
Public method CreateFolderOnDtsServer Infrastructure. Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. 
Public method CreateFolderOnSQLServer Infrastructure. Creates a folder on the specified instance of SQL Server.
Public method CreateSsisServerExecution Infrastructure. Creates SSIS server execution.
Public method DataTypeInfoFromDataType Infrastructure. Returns the IDTSDataTypeInfo100 object for the specified data type.
Public method ExistsOnDtsServer Infrastructure. Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
Public method ExistsOnSQLServer Infrastructure. Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
Public method FolderExistsOnDtsServer Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system.
Public method FolderExistsOnSQLServer Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
Public method FolderFromPath Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system.
Public method GetDtsServerPackageInfos Infrastructure. Gets a IDTSPackageInfos100 collection that contains the packages stored in the SSIS Package Store on an instance of SQL Server, within the specified folder.
Public method GetDtsServerRoles Infrastructure. Returns an array of Strings that lists the roles available for a folder.
Public method GetPackageInfos Infrastructure. Gets a IDTSPackageInfos100 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 method GetPackageInfos2 Infrastructure. Gets a IDTSPackageInfos100 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 method GetPackageRoles Infrastructure. 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.
Public method GetRunningPackages Infrastructure. Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only.
Public method GetServerInfo Infrastructure. Returns the SQL Server version number of the SQL Server product installed on the target server. 
Public method GetServerVersionEx Infrastructure. Returns the edition, product level, and other values that indicate the version of SSIS installed.
Public method LoadFromDtsServer Infrastructure. Loads a package from the specified server, and specifies the threading model.
Public method LoadFromSQLServer Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password.
Public method LoadFromSQLServer2 Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password.
Public method LoadPackage Infrastructure. Loads a IDTSPackage100 from the file system.
Public method OpenProject Infrastructure. Opens a specified project.
Public method RemoveFolderFromDtsServer Infrastructure. Removes the specified folder from the specified server.
Public method RemoveFolderFromSQLServer Infrastructure. Removes the specified folder from the specified instance of SQL Server.
Public method RemoveFromDtsServer Infrastructure. Removes a package from the specified server.
Public method RemoveFromSQLServer Infrastructure. Removes a package from the specified instance of SQL Server.
Public method RenameFolderOnDtsServer Infrastructure. Renames a folder on the specified server.
Public method RenameFolderOnSQLServer Infrastructure. Renames a folder on the specified instance of SQL Server.
Public method SavePackage Infrastructure. Saves a package to the file system.
Public method SaveToDtsServer Infrastructure. Saves a package to the specified server.
Public method SaveToSQLServer Infrastructure. Saves a package to an instance of SQL Server.
Public method SaveToSQLServerAs Infrastructure. Saves a package to an instance of SQL Server with a new name.
Public method SaveToXML Infrastructure. Saves the XML definition of a package to a file.
Public method SetPackageRoles Infrastructure. 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.

Top

Remarks

For more information, see ApplicationClass.

See Also

Reference

Microsoft.SqlServer.Dts.Runtime.Wrapper Namespace