Interface IDTSApplication100
Cette API prend en charge l'infrastructure SQL Server 2012 et n'est pas destinée à être utilisée directement à partir de votre code.
Provides properties and methods that are used to discover and access Package objects.
Espace de noms : Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly : Microsoft.SqlServer.DTSRuntimeWrap (en Microsoft.SqlServer.DTSRuntimeWrap.dll)
Syntaxe
'Déclaration
<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")> _
Public Interface IDTSApplication100
'Utilisation
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
Le type IDTSApplication100 expose les membres suivants.
Propriétés
Nom | 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. |
Haut de la page
Méthodes
Nom | 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. |
Haut de la page
Notes
For more information, see ApplicationClass.