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
	CheckSignatureOnLoad	Infrastructure. Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
	ComponentStorePath	Infrastructure. Returns the path where pipeline components are stored. This property is read-only.
	ConnectionInfos	Infrastructure. Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only.
	DataTypeInfos	Infrastructure. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only.
	DBProviderInfos	Infrastructure. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only.
	ForEachEnumeratorInfos	Infrastructure. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only.
	LogProviderInfos	Infrastructure. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only.
	PackagePassword	Infrastructure. Sets the value of the password for the package. This property is write-only.
	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.
	PipelineComponentInfos	Infrastructure. Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects.
	ProjectPassword	Infrastructure. Sets the value of the password for the project. This property is write-only.
	TaskInfos	Infrastructure. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only.
	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.
	UpdatePackage	Infrastructure. Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.

Top

Methods

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