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 命名空間