共用方式為


IDTSApplication100 Interface

Definition

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

public interface class IDTSApplication100
[System.Runtime.InteropServices.Guid("CCE32398-CDF8-47D2-A04F-1EFCA3548481")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
public interface IDTSApplication100
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
[System.Runtime.InteropServices.Guid("DD7CDFC6-F283-434E-8C08-4703871D7B07")]
public interface IDTSApplication100
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
[System.Runtime.InteropServices.Guid("56B5BFC8-15B2-433B-931B-96295EEC1667")]
public interface IDTSApplication100
[<System.Runtime.InteropServices.Guid("CCE32398-CDF8-47D2-A04F-1EFCA3548481")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
type IDTSApplication100 = interface
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
[<System.Runtime.InteropServices.Guid("DD7CDFC6-F283-434E-8C08-4703871D7B07")>]
type IDTSApplication100 = interface
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
[<System.Runtime.InteropServices.Guid("56B5BFC8-15B2-433B-931B-96295EEC1667")>]
type IDTSApplication100 = interface
Public Interface IDTSApplication100
Derived
Attributes

Remarks

For more information, see ApplicationClass.

Properties

CheckSignatureOnLoad

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

ComponentStorePath

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

ConnectionInfos

Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only.

DataTypeInfos

Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only.

DBProviderInfos

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

ForEachEnumeratorInfos

Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only.

LogProviderInfos

Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only.

PackagePassword

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

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

Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects.

ProjectPassword

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

TaskInfos

Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only.

UpdateObjects

Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found.

UpdatePackage

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

Methods

CloseProject(IDTSProject100)

Closes a specified project.

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)

Creates a folder on the specified instance of SQL Server.

CreateSsisServerExecution(String, String, String, Boolean)

Creates SSIS server execution.

DataTypeInfoFromDataType(DataType)

Returns the IDTSDataTypeInfo100 object for the specified data type.

ExistsOnDtsServer(String, String)

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

ExistsOnSQLServer(String, String, String, String)

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

FolderExistsOnDtsServer(String, String)

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

FolderExistsOnSQLServer(String, String, String, String)

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

FolderFromPath(String, String, String, String)

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

GetDtsServerPackageInfos(String, String)

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

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

GetPackageInfos(String, String, String, String)

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

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(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)

Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only.

GetServerInfo(String, String)

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

GetServerVersionEx(String, UInt32, DTSProductLevel, String, String)

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

LoadFromDtsServer(String, String, Boolean, IDTSEvents100)

Loads a package from the specified server, and specifies the threading model.

LoadFromSQLServer(String, String, String, String, Boolean, IDTSEvents100)

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

LoadFromSQLServer2(String, Object, Boolean, IDTSEvents100)

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

LoadPackage(String, Boolean, IDTSEvents100)

Loads a IDTSPackage100 from the file system.

OpenProject(String, IDTSEvents100)

Opens a specified project.

RemoveFolderFromDtsServer(String, String)

Removes the specified folder from the specified server.

RemoveFolderFromSQLServer(String, String, String, String)

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

RemoveFromDtsServer(String, String)

Removes a package from the specified server.

RemoveFromSQLServer(String, String, String, String)

Removes a package from the specified instance of SQL Server.

RenameFolderOnDtsServer(String, String, String, String)

Renames a folder on the specified server.

RenameFolderOnSQLServer(String, String, String, String, String, String)

Renames a folder on the specified instance of SQL Server.

SavePackage(String, IDTSPackage100, IDTSEvents100)

Saves a package to the file system.

SaveToDtsServer(IDTSPackage100, IDTSEvents100, String, String)

Saves a package to the specified server.

SaveToSQLServer(IDTSPackage100, IDTSEvents100, String, String, String)

Saves a package to an instance of SQL Server.

SaveToSQLServerAs(IDTSPackage100, IDTSEvents100, String, String, String, String)

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

SaveToXML(String, IDTSPersist100, IDTSEvents100)

Saves the XML definition of a package to a file.

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.

Applies to