Compartir a través de


Interfaz IDTSApplication100

Esta API admite la infraestructura de SQL Server 2012 y no está prevista su utilización directa desde el código.

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

Espacio de nombres:  Microsoft.SqlServer.Dts.Runtime.Wrapper
Ensamblado:  Microsoft.SqlServer.DTSRuntimeWrap (en Microsoft.SqlServer.DTSRuntimeWrap.dll)

Sintaxis

'Declaración
<GuidAttribute("E8102616-3E24-4827-85B2-4897E71B598B")> _
Public Interface IDTSApplication100
'Uso
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

El tipo IDTSApplication100 expone los siguientes miembros.

Propiedades

  Nombre Descripción
Propiedad pública CheckSignatureOnLoad Infraestructura. Gets or sets a value that indicates whether the runtime should check the digital signature of the package when loading the package.
Propiedad pública ComponentStorePath Infraestructura. Returns the path where pipeline components are stored. This property is read-only.
Propiedad pública ConnectionInfos Infraestructura. Returns a IDTSConnectionInfos100 collection that contains IDTSConnectionInfo100 objects. This property is read-only.
Propiedad pública DataTypeInfos Infraestructura. Returns a IDTSDataTypeInfos100 collection that contains IDTSDataTypeInfo100 objects. This property is read-only.
Propiedad pública DBProviderInfos Infraestructura. Returns a IDTSDBProviderInfos100 collection that contains IDTSDBProviderInfo100 objects in the application. This property is read-only.
Propiedad pública ForEachEnumeratorInfos Infraestructura. Returns a IDTSForEachEnumeratorInfos100 collection that contains IDTSForEachEnumeratorInfo100 objects. This property is read-only.
Propiedad pública LogProviderInfos Infraestructura. Returns a IDTSLogProviderInfos100 collection that contains IDTSLogProviderInfo100 objects. This property is read-only.
Propiedad pública PackagePassword Infraestructura. Sets the value of the password for the package. This property is write-only.
Propiedad pública PackageUpgradeOptions Infraestructura. Gets or sets a value that indicates which upgrade options will be applied to a collection of Integration Services packages during the upgrade process.
Propiedad pública PipelineComponentInfos Infraestructura. Returns a IDTSPipelineComponentInfos100 collection that contains IDTSPipelineComponentInfo100 objects.
Propiedad pública ProjectPassword Infraestructura. Sets the value of the password for the project. This property is write-only.
Propiedad pública TaskInfos Infraestructura. Returns a IDTSTaskInfos100 collection that contains IDTSTaskInfo100 objects. This property is read-only.
Propiedad pública UpdateObjects Infraestructura. Gets or sets a Boolean that indicates whether extensible objects can be updated at package load time if an updated version is found.
Propiedad pública UpdatePackage Infraestructura. Gets or sets a Boolean that indicates whether packages can be updated when an updated version is found.

Arriba

Métodos

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

Arriba

Comentarios

For more information, see ApplicationClass.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Dts.Runtime.Wrapper