共用方式為


IDTSApplication100 介面

此 API 支援 SQL Server 2012 基礎結構,但無法直接從您的程式碼使用。

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

命名空間:  Microsoft.SqlServer.Dts.Runtime.Wrapper
組件:  Microsoft.SqlServer.DTSRuntimeWrap (在 Microsoft.SqlServer.DTSRuntimeWrap.dll 中)

語法

'宣告
<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")> _
Public Interface IDTSApplication100
'用途
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

IDTSApplication100 型別公開下列成員。

屬性

  名稱 說明
公用屬性 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.

上層

方法

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

上層

備註

For more information, see ApplicationClass.

請參閱

參考

Microsoft.SqlServer.Dts.Runtime.Wrapper 命名空間