Partager via


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
Propriété publique CheckSignatureOnLoad Infrastructure. Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
Propriété publique ComponentStorePath Infrastructure. Returns the path where pipeline components are stored. This property is read-only.
Propriété publique ConnectionInfos Infrastructure. Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only.
Propriété publique DataTypeInfos Infrastructure. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only.
Propriété publique DBProviderInfos Infrastructure. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only.
Propriété publique ForEachEnumeratorInfos Infrastructure. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only.
Propriété publique LogProviderInfos Infrastructure. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only.
Propriété publique PackagePassword Infrastructure. Sets the value of the password for the package. This property is write-only.
Propriété publique 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.
Propriété publique PipelineComponentInfos Infrastructure. Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects.
Propriété publique ProjectPassword Infrastructure. Sets the value of the password for the project. This property is write-only.
Propriété publique TaskInfos Infrastructure. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only.
Propriété publique 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.
Propriété publique 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
Méthode publique CloseProject Infrastructure. Closes a specified project.
Méthode publique CreateFolderOnDtsServer Infrastructure. Creates a folder on the server that appears in the Stored Packages node of the Integration Services service hierarchy. 
Méthode publique CreateFolderOnSQLServer Infrastructure. Creates a folder on the specified instance of SQL Server.
Méthode publique CreateSsisServerExecution Infrastructure. Creates SSIS server execution.
Méthode publique DataTypeInfoFromDataType Infrastructure. Returns the IDTSDataTypeInfo100 object for the specified data type.
Méthode publique ExistsOnDtsServer Infrastructure. Returns a Boolean that indicates whether the specified package already exists on the Integration Services service.
Méthode publique ExistsOnSQLServer Infrastructure. Returns a Boolean that indicates whether the specified package exists on the instance of SQL Server.
Méthode publique FolderExistsOnDtsServer Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system.
Méthode publique FolderExistsOnSQLServer Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the instance of SQL Server.
Méthode publique FolderFromPath Infrastructure. Returns a Boolean that indicates whether the specified folder already exists on the file system.
Méthode publique 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.
Méthode publique GetDtsServerRoles Infrastructure. Returns an array of Strings that lists the roles available for a folder.
Méthode publique 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.
Méthode publique 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.
Méthode publique 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.
Méthode publique GetRunningPackages Infrastructure. Returns a IDTSRunningPackages100 collection that contains IDTSRunningPackage100 objects. This property is read-only.
Méthode publique GetServerInfo Infrastructure. Returns the SQL Server version number of the SQL Server product installed on the target server. 
Méthode publique GetServerVersionEx Infrastructure. Returns the edition, product level, and other values that indicate the version of SSIS installed.
Méthode publique LoadFromDtsServer Infrastructure. Loads a package from the specified server, and specifies the threading model.
Méthode publique LoadFromSQLServer Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password.
Méthode publique LoadFromSQLServer2 Infrastructure. Loads a package from SQL Server by specifying the server name, user name, and password.
Méthode publique LoadPackage Infrastructure. Loads a IDTSPackage100 from the file system.
Méthode publique OpenProject Infrastructure. Opens a specified project.
Méthode publique RemoveFolderFromDtsServer Infrastructure. Removes the specified folder from the specified server.
Méthode publique RemoveFolderFromSQLServer Infrastructure. Removes the specified folder from the specified instance of SQL Server.
Méthode publique RemoveFromDtsServer Infrastructure. Removes a package from the specified server.
Méthode publique RemoveFromSQLServer Infrastructure. Removes a package from the specified instance of SQL Server.
Méthode publique RenameFolderOnDtsServer Infrastructure. Renames a folder on the specified server.
Méthode publique RenameFolderOnSQLServer Infrastructure. Renames a folder on the specified instance of SQL Server.
Méthode publique SavePackage Infrastructure. Saves a package to the file system.
Méthode publique SaveToDtsServer Infrastructure. Saves a package to the specified server.
Méthode publique SaveToSQLServer Infrastructure. Saves a package to an instance of SQL Server.
Méthode publique SaveToSQLServerAs Infrastructure. Saves a package to an instance of SQL Server with a new name.
Méthode publique SaveToXML Infrastructure. Saves the XML definition of a package to a file.
Méthode publique 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.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Dts.Runtime.Wrapper