Export (0) Print
Expand All

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)

[TypeLibTypeAttribute(TypeLibTypeFlags.FDual|TypeLibTypeFlags.FDispatchable)]
[GuidAttribute("C0262265-5F9D-4821-9277-573210B5AF29")]
public interface IDTSApplication100

The IDTSApplication100 type exposes the following members.

  NameDescription
Public propertyCheckSignatureOnLoadInfrastructure. Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
Public propertyComponentStorePathInfrastructure. Returns the path where pipeline components are stored. This property is read-only.
Public propertyConnectionInfosInfrastructure. Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only.
Public propertyDataTypeInfosInfrastructure. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only.
Public propertyDBProviderInfosInfrastructure. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only.
Public propertyForEachEnumeratorInfosInfrastructure. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only.
Public propertyLogProviderInfosInfrastructure. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only.
Public propertyPackagePasswordInfrastructure. Sets the value of the password for the package. This property is write-only.
Public propertyPackageUpgradeOptionsInfrastructure. 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 propertyPipelineComponentInfosInfrastructure. Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects.
Public propertyProjectPasswordInfrastructure. Sets the value of the password for the project. This property is write-only.
Public propertyTaskInfosInfrastructure. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only.
Public propertyUpdateObjectsInfrastructure. Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found.
Public propertyUpdatePackageInfrastructure. Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.
Top

  NameDescription
Public methodCloseProjectInfrastructure. Closes a specified project.
Public methodCreateFolderOnDtsServerInfrastructure. Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. 
Public methodCreateFolderOnSQLServerInfrastructure. Creates a folder on the specified instance of SQL Server.
Public methodCreateSsisServerExecutionInfrastructure. Creates SSIS server execution.
Public methodDataTypeInfoFromDataTypeInfrastructure. Returns the IDTSDataTypeInfo100 object for the specified data type.
Public methodExistsOnDtsServerInfrastructure. Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
Public methodExistsOnSQLServerInfrastructure. Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
Public methodFolderExistsOnDtsServerInfrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system.
Public methodFolderExistsOnSQLServerInfrastructure. Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
Public methodFolderFromPathInfrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system.
Public methodGetDtsServerPackageInfosInfrastructure. 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 methodGetDtsServerRolesInfrastructure. Returns an array of Strings that lists the roles available for a folder.
Public methodGetPackageInfosInfrastructure. 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 methodGetPackageInfos2Infrastructure. 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 methodGetPackageRolesInfrastructure. 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 methodGetRunningPackagesInfrastructure. Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only.
Public methodGetServerInfoInfrastructure. Returns the SQL Server version number of the SQL Server product installed on the target server. 
Public methodGetServerVersionExInfrastructure. Returns the edition, product level, and other values that indicate the version of SSIS installed.
Public methodLoadFromDtsServerInfrastructure. Loads a package from the specified server, and specifies the threading model.
Public methodLoadFromSQLServerInfrastructure. Loads 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 methodLoadPackageInfrastructure. Loads a IDTSPackage100 from the file system.
Public methodOpenProjectInfrastructure. Opens a specified project.
Public methodRemoveFolderFromDtsServerInfrastructure. Removes the specified folder from the specified server.
Public methodRemoveFolderFromSQLServerInfrastructure. Removes the specified folder from the specified instance of SQL Server.
Public methodRemoveFromDtsServerInfrastructure. Removes a package from the specified server.
Public methodRemoveFromSQLServerInfrastructure. Removes a package from the specified instance of SQL Server.
Public methodRenameFolderOnDtsServerInfrastructure. Renames a folder on the specified server.
Public methodRenameFolderOnSQLServerInfrastructure. Renames a folder on the specified instance of SQL Server.
Public methodSavePackageInfrastructure. Saves a package to the file system.
Public methodSaveToDtsServerInfrastructure. Saves a package to the specified server.
Public methodSaveToSQLServerInfrastructure. Saves a package to an instance of SQL Server.
Public methodSaveToSQLServerAsInfrastructure. Saves a package to an instance of SQL Server with a new name.
Public methodSaveToXMLInfrastructure. Saves the XML definition of a package to a file.
Public methodSetPackageRolesInfrastructure. 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

For more information, see ApplicationClass.

Community Additions

ADD
Show:
© 2014 Microsoft