ConnectionManagerExcelClass Class

Article
04/26/2013

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

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

Inheritance Hierarchy

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

The ConnectionManagerExcelClass type exposes the following members.

Constructors

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

Top

Properties

	Name	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.

Top

Methods

	Name	Description
	AcquireConnection	Infrastructure. Creates an instance of the connection type.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetConnectionForSchema	Infrastructure. Gets the connection for the schema.
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from 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	(Inherited from Object.)
	Validate	Infrastructure. Validates the connection and returns an enumeration that indicates success or failure.

Top

Remarks

For more information, see ConnectionManager.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Share via