Classe ConnectionManagerExcelClass

Questa API supporta l'infrastruttura SQL Server 2012 e non può essere utilizzata direttamente dal codice.

Represents a connection manager that connects to an Excel workbook file.

Gerarchia di ereditarietà

System.Object
  Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerExcelClass

Spazio dei nomi  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

Sintassi

'Dichiarazione
<ClassInterfaceAttribute(ClassInterfaceType.None)> _
<GuidAttribute("01F2E8D5-1D00-4B7E-A297-0C122AFE4081")> _
Public Class ConnectionManagerExcelClass _
    Implements IDTSConnectionManager100, ConnectionManagerExcel, IDTSConnectionManagerExcel100, IDTSConnectionManagerDatabaseParameters100
'Utilizzo
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

Nel tipo ConnectionManagerExcelClass sono esposti i membri seguenti.

Costruttori

	Nome	Descrizione
	ConnectionManagerExcelClass	Infrastruttura. Initializes a new instance of the ConnectionManagerExcelClass class.

In alto

Proprietà

	Nome	Descrizione
	ConnectionString	Infrastruttura. Gets or sets the connection string used to establish a connection to a data source.
	ExcelFilePath	Infrastruttura. Gets or sets the path of the Excel workbook file.
	ExcelVersionNumber	Infrastruttura. Gets or sets the version of Excel that was used to create the file.
	FirstRowHasColumnName	Infrastruttura. Gets or sets a Boolean that indicates whether the first contains the column name.
	InitialCatalog	Infrastruttura. Gets or sets the initial catalog for the connection.
	Password	Infrastruttura. Gets or sets the password for the connection.
	ProtectionLevel	Infrastruttura. Gets or sets the level of encryption performed on sensitive data that is contained in the package.
	RetainSameConnection	Infrastruttura. Gets or sets a Boolean that indicates whether the connection manager retains the same connection.
	Scope	Infrastruttura. Gets the scope of the connection manager.
	ServerName	Infrastruttura. Gets or sets the server name.
	SupportsDTCTransactions	Infrastruttura. Gets a Boolean that indicates whether the connection supports Microsoft Distributed Transaction Coordinator (MS DTC) transactions.
	UserName	Infrastruttura. Gets or sets the username for the connection.

In alto

Metodi

	Nome	Descrizione
	AcquireConnection	Infrastruttura. Creates an instance of the connection type.
	Equals	Ereditato da Object.
	Finalize	Ereditato da Object.
	GetConnectionForSchema	Infrastruttura. Gets the connection for the schema.
	GetHashCode	Ereditato da Object.
	GetType	Ereditato da Object.
	MemberwiseClone	Ereditato da Object.
	ReleaseConnection	Infrastruttura. Frees the connection established during AcquireConnection. Called at design time and runtime.
	SetQualifier	Infrastruttura. Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.
	ToString	Ereditato da Object.
	Validate	Infrastruttura. Validates the connection and returns an enumeration that indicates success or failure.

In alto

Osservazioni

For more information, see ConnectionManager.

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Dts.Runtime.Wrapper