Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Diese API unterstützt die SQL Server 2012-Infrastruktur und ist nicht zur direkten Verwendung im Code bestimmt.
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
Der IDTSApplication100-Typ macht folgende Elemente verfügbar.
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
![]() |
CheckSignatureOnLoad | Infrastruktur Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package. |
![]() |
ComponentStorePath | Infrastruktur Returns the path where pipeline components are stored. This property is read-only. |
![]() |
ConnectionInfos | Infrastruktur Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only. |
![]() |
DataTypeInfos | Infrastruktur Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only. |
![]() |
DBProviderInfos | Infrastruktur Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only. |
![]() |
ForEachEnumeratorInfos | Infrastruktur Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only. |
![]() |
LogProviderInfos | Infrastruktur Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only. |
![]() |
PackagePassword | Infrastruktur Sets the value of the password for the package. This property is write-only. |
![]() |
PackageUpgradeOptions | Infrastruktur 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 | Infrastruktur Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects. |
![]() |
ProjectPassword | Infrastruktur Sets the value of the password for the project. This property is write-only. |
![]() |
TaskInfos | Infrastruktur Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only. |
![]() |
UpdateObjects | Infrastruktur Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found. |
![]() |
UpdatePackage | Infrastruktur Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found. |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
![]() |
CloseProject | Infrastruktur Closes a specified project. |
![]() |
CreateFolderOnDtsServer | Infrastruktur Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. |
![]() |
CreateFolderOnSQLServer | Infrastruktur Creates a folder on the specified instance of SQL Server. |
![]() |
CreateSsisServerExecution | Infrastruktur Creates SSIS server execution. |
![]() |
DataTypeInfoFromDataType | Infrastruktur Returns the IDTSDataTypeInfo100 object for the specified data type. |
![]() |
ExistsOnDtsServer | Infrastruktur Returns a Boolean that indicates whether the specified package already exists on the Integration Services service. |
![]() |
ExistsOnSQLServer | Infrastruktur Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server. |
![]() |
FolderExistsOnDtsServer | Infrastruktur Returns a Boolean that indicates whether the specified folder already exists on the file system. |
![]() |
FolderExistsOnSQLServer | Infrastruktur Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server. |
![]() |
FolderFromPath | Infrastruktur Returns a Boolean that indicates whether the specified folder already exists on the file system. |
![]() |
GetDtsServerPackageInfos | Infrastruktur 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 | Infrastruktur Returns an array of Strings that lists the roles available for a folder. |
![]() |
GetPackageInfos | Infrastruktur 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 | Infrastruktur 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 | Infrastruktur 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 | Infrastruktur Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only. |
![]() |
GetServerInfo | Infrastruktur Returns the SQL Server version number of the SQL Server product installed on the target server. |
![]() |
GetServerVersionEx | Infrastruktur Returns the edition, product level, and other values that indicate the version of SSIS installed. |
![]() |
LoadFromDtsServer | Infrastruktur Loads a package from the specified server, and specifies the threading model. |
![]() |
LoadFromSQLServer | Infrastruktur Loads a package from SQL Server by specifying the server name, user name, and password. |
![]() |
LoadFromSQLServer2 | Infrastruktur Loads a package from SQL Server by specifying the server name, user name, and password. |
![]() |
LoadPackage | Infrastruktur Loads a IDTSPackage100 from the file system. |
![]() |
OpenProject | Infrastruktur Opens a specified project. |
![]() |
RemoveFolderFromDtsServer | Infrastruktur Removes the specified folder from the specified server. |
![]() |
RemoveFolderFromSQLServer | Infrastruktur Removes the specified folder from the specified instance of SQL Server. |
![]() |
RemoveFromDtsServer | Infrastruktur Removes a package from the specified server. |
![]() |
RemoveFromSQLServer | Infrastruktur Removes a package from the specified instance of SQL Server. |
![]() |
RenameFolderOnDtsServer | Infrastruktur Renames a folder on the specified server. |
![]() |
RenameFolderOnSQLServer | Infrastruktur Renames a folder on the specified instance of SQL Server. |
![]() |
SavePackage | Infrastruktur Saves a package to the file system. |
![]() |
SaveToDtsServer | Infrastruktur Saves a package to the specified server. |
![]() |
SaveToSQLServer | Infrastruktur Saves a package to an instance of SQL Server. |
![]() |
SaveToSQLServerAs | Infrastruktur Saves a package to an instance of SQL Server with a new name. |
![]() |
SaveToXML | Infrastruktur Saves the XML definition of a package to a file. |
![]() |
SetPackageRoles | Infrastruktur 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. |
Zum Anfang
Hinweise
For more information, see ApplicationClass.
.gif)
.gif)