Classe ConnectionManagerExcelClass

Cette API prend en charge l'infrastructure SQL Server 2012 et n'est pas destinée à être utilisée directement à partir de votre code.

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

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly :  Microsoft.SqlServer.DTSRuntimeWrap (en Microsoft.SqlServer.DTSRuntimeWrap.dll)

Syntaxe

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

Le type ConnectionManagerExcelClass expose les membres suivants.

Constructeurs

	Nom	Description
	ConnectionManagerExcelClass	Infrastructure. Initializes a new instance of the ConnectionManagerExcelClass class.

Haut de la page

Propriétés

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

Haut de la page

Méthodes

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

Haut de la page

Notes

For more information, see ConnectionManager.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

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