ConnectionManagerExcelClass-Klasse

Diese API unterstützt die SQL Server 2012-Infrastruktur und ist nicht zur direkten Verwendung im Code bestimmt.

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

Vererbungshierarchie

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

Namespace:  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly:  Microsoft.SqlServer.DTSRuntimeWrap (in Microsoft.SqlServer.DTSRuntimeWrap.dll)

Syntax

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

Der ConnectionManagerExcelClass-Typ macht folgende Elemente verfügbar.

Konstruktoren

	Name	Beschreibung
	ConnectionManagerExcelClass	Infrastruktur Initializes a new instance of the ConnectionManagerExcelClass class.

Zum Anfang

Eigenschaften

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

Zum Anfang

Methoden

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

Zum Anfang

Hinweise

For more information, see ConnectionManager.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Dts.Runtime.Wrapper-Namespace