ConnectionManagerExcelClass Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime.Wrapper

Assembly:: Microsoft.SqlServer.DTSRuntimeWrap.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public ref class ConnectionManagerExcelClass : Microsoft::SqlServer::Dts::Runtime::Wrapper::ConnectionManagerExcel, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerDatabaseParameters100, Microsoft::SqlServer::Dts::Runtime::Wrapper::IDTSConnectionManagerExcel100

[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.Guid("223D2E6E-492B-4866-9C9E-07FF3665D089")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
public class ConnectionManagerExcelClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerExcel, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerExcel100

[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("3E63BCE0-F56D-47B5-B884-61675F44D511")]
public class ConnectionManagerExcelClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerExcel, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerExcel100

[System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)]
[System.Runtime.InteropServices.Guid("8FF0D90E-21F9-4705-AA95-CC2304469315")]
public class ConnectionManagerExcelClass : Microsoft.SqlServer.Dts.Runtime.Wrapper.ConnectionManagerExcel, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerDatabaseParameters100, Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManagerExcel100

[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.Guid("223D2E6E-492B-4866-9C9E-07FF3665D089")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
type ConnectionManagerExcelClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerExcel
    interface IDTSConnectionManagerExcel100
    interface IDTSConnectionManagerDatabaseParameters100

[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("3E63BCE0-F56D-47B5-B884-61675F44D511")>]
type ConnectionManagerExcelClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerExcel
    interface IDTSConnectionManagerExcel100
    interface IDTSConnectionManagerDatabaseParameters100

[<System.Runtime.InteropServices.ClassInterface(System.Runtime.InteropServices.ClassInterfaceType.None)>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FCanCreate)>]
[<System.Runtime.InteropServices.Guid("8FF0D90E-21F9-4705-AA95-CC2304469315")>]
type ConnectionManagerExcelClass = class
    interface IDTSConnectionManager100
    interface ConnectionManagerExcel
    interface IDTSConnectionManagerExcel100
    interface IDTSConnectionManagerDatabaseParameters100

Public Class ConnectionManagerExcelClass
Implements ConnectionManagerExcel, IDTSConnectionManagerDatabaseParameters100, IDTSConnectionManagerExcel100

Inheritance: Object
ConnectionManagerExcelClass

Attributes: ClassInterfaceAttribute GuidAttribute TypeLibTypeAttribute

Implements: ConnectionManagerExcel IDTSConnectionManager100 IDTSConnectionManagerDatabaseParameters100 IDTSConnectionManagerExcel100

Remarks

For more information, see ConnectionManager.

Constructors

ConnectionManagerExcelClass()

Initializes a new instance of the ConnectionManagerExcelClass class.

Properties

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

Methods

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

Applies to