ConnectionManagerExcelClass 类

此 API 支持 SQL Server 2012 基础结构，但不能通过代码直接使用。

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

继承层次结构

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

命名空间：  Microsoft.SqlServer.Dts.Runtime.Wrapper
程序集：  Microsoft.SqlServer.DTSRuntimeWrap（在 Microsoft.SqlServer.DTSRuntimeWrap.dll 中）

语法

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

ConnectionManagerExcelClass 类型公开以下成员。

构造函数

	名称	说明
	ConnectionManagerExcelClass	基础结构。Initializes a new instance of the ConnectionManagerExcelClass class.

页首

属性

	名称	说明
	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.

页首

方法

	名称	说明
	AcquireConnection	基础结构。Creates an instance of the connection type.
	Equals	（从 Object 继承。）
	Finalize	（从 Object 继承。）
	GetConnectionForSchema	基础结构。Gets the connection for the schema.
	GetHashCode	（从 Object 继承。）
	GetType	（从 Object 继承。）
	MemberwiseClone	（从 Object 继承。）
	ReleaseConnection	基础结构。Frees the connection established during AcquireConnection. Called at design time and runtime.
	SetQualifier	基础结构。Changes a qualifier on the connection manager after the connection manager has been created but before it is used in a running package.
	ToString	（从 Object 继承。）
	Validate	基础结构。Validates the connection and returns an enumeration that indicates success or failure.

页首

注释

For more information, see ConnectionManager.

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Dts.Runtime.Wrapper 命名空间