Clase ConnectionManagerExcelClass
Esta API admite la infraestructura de SQL Server 2012 y no está prevista su utilización directa desde el código.
Represents a connection manager that connects to an Excel workbook file.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerExcelClass
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime.Wrapper
Ensamblado: Microsoft.SqlServer.DTSRuntimeWrap (en Microsoft.SqlServer.DTSRuntimeWrap.dll)
Sintaxis
'Declaración
<ClassInterfaceAttribute(ClassInterfaceType.None)> _
<GuidAttribute("01F2E8D5-1D00-4B7E-A297-0C122AFE4081")> _
Public Class ConnectionManagerExcelClass _
Implements IDTSConnectionManager100, ConnectionManagerExcel, IDTSConnectionManagerExcel100, IDTSConnectionManagerDatabaseParameters100
'Uso
Dim instance As ConnectionManagerExcelClass
[ClassInterfaceAttribute(ClassInterfaceType.None)]
[GuidAttribute("01F2E8D5-1D00-4B7E-A297-0C122AFE4081")]
public class ConnectionManagerExcelClass : IDTSConnectionManager100,
ConnectionManagerExcel, IDTSConnectionManagerExcel100, IDTSConnectionManagerDatabaseParameters100
[ClassInterfaceAttribute(ClassInterfaceType::None)]
[GuidAttribute(L"01F2E8D5-1D00-4B7E-A297-0C122AFE4081")]
public ref class ConnectionManagerExcelClass : IDTSConnectionManager100,
ConnectionManagerExcel, IDTSConnectionManagerExcel100, IDTSConnectionManagerDatabaseParameters100
[<ClassInterfaceAttribute(ClassInterfaceType.None)>]
[<GuidAttribute("01F2E8D5-1D00-4B7E-A297-0C122AFE4081")>]
type ConnectionManagerExcelClass =
class
interface IDTSConnectionManager100
interface ConnectionManagerExcel
interface IDTSConnectionManagerExcel100
interface IDTSConnectionManagerDatabaseParameters100
end
public class ConnectionManagerExcelClass implements IDTSConnectionManager100, ConnectionManagerExcel, IDTSConnectionManagerExcel100, IDTSConnectionManagerDatabaseParameters100
El tipo ConnectionManagerExcelClass expone los siguientes miembros.
Constructores
| Nombre | Descripción | |
|---|---|---|
.gif "Método público") |
ConnectionManagerExcelClass | Infraestructura. Initializes a new instance of the ConnectionManagerExcelClass class. |
Arriba
Propiedades
| Nombre | Descripción | |
|---|---|---|
.gif "Propiedad pública") |
ConnectionString | Infraestructura. Gets or sets the connection string used to establish a connection to a data source. |
|
ExcelFilePath | Infraestructura. Gets or sets the path of the Excel workbook file. |
|
ExcelVersionNumber | Infraestructura. Gets or sets the version of Excel that was used to create the file. |
|
FirstRowHasColumnName | Infraestructura. Gets or sets a Boolean that indicates whether the first contains the column name. |
|
InitialCatalog | Infraestructura. Gets or sets the initial catalog for the connection. |
|
Password | Infraestructura. Gets or sets the password for the connection. |
|
ProtectionLevel | Infraestructura. Gets or sets the level of encryption performed on sensitive data that is contained in the package. |
|
RetainSameConnection | Infraestructura. Gets or sets a Boolean that indicates whether the connection manager retains the same connection. |
|
Scope | Infraestructura. Gets the scope of the connection manager. |
|
ServerName | Infraestructura. Gets or sets the server name. |
|
SupportsDTCTransactions | Infraestructura. Gets a Boolean that indicates whether the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions. |
|
UserName | Infraestructura. Gets or sets the username for the connection. |
Arriba
Métodos
| Nombre | Descripción | |
|---|---|---|
|
AcquireConnection | Infraestructura. Creates an instance of the connection type. |
|
Equals | (Se hereda de Object.) |
.gif "Método protegido") |
Finalize | (Se hereda de Object.) |
|
GetConnectionForSchema | Infraestructura. Gets the connection for the schema. |
|
GetHashCode | (Se hereda de Object.) |
|
GetType | (Se hereda de Object.) |
|
MemberwiseClone | (Se hereda de Object.) |
|
ReleaseConnection | Infraestructura. Frees the connection established during AcquireConnection. Called at design time and runtime. |
|
SetQualifier | Infraestructura. Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package. |
|
ToString | (Se hereda de Object.) |
|
Validate | Infraestructura. Validates the connection and returns an enumeration that indicates success or failure. |
Arriba
Comentarios
For more information, see ConnectionManager.
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.