共用方式為


IDTSBuffer100 介面

Represents an in-memory, two-dimensional storage object that contains rows and columns.

命名空間:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
組件:  Microsoft.SqlServer.DTSPipelineWrap (在 Microsoft.SqlServer.DTSPipelineWrap.dll 中)

語法

'宣告
<GuidAttribute("85864348-F482-4E59-83B7-DCD226253CA3")> _
<InterfaceTypeAttribute()> _
Public Interface IDTSBuffer100
'用途
Dim instance As IDTSBuffer100
[GuidAttribute("85864348-F482-4E59-83B7-DCD226253CA3")]
[InterfaceTypeAttribute()]
public interface IDTSBuffer100
[GuidAttribute(L"85864348-F482-4E59-83B7-DCD226253CA3")]
[InterfaceTypeAttribute()]
public interface class IDTSBuffer100
[<GuidAttribute("85864348-F482-4E59-83B7-DCD226253CA3")>]
[<InterfaceTypeAttribute()>]
type IDTSBuffer100 =  interface end
public interface IDTSBuffer100

IDTSBuffer100 型別公開下列成員。

方法

  名稱 說明
公用方法 AddBLOBData Appends byte data to a column in an IDTSBuffer100.
公用方法 AddRow Adds a new row to an IDTSBuffer100 object.
公用方法 Clone Creates a private copy of an IDTSBuffer100 object.
公用方法 DirectErrorRow Sends a row in an IDTSBuffer100 object to an IDTSOutput100 whose IsErrorOut property is true.
公用方法 DirectRow Sends a row in an IDTSBuffer100 to an IDTSOutput100.
公用方法 GetBLOBData Retrieves an array of bytes from a binary large object (BLOB) stored in a column of a IDTSBuffer100.
公用方法 GetBLOBLength Gets the number of bytes contained in a column in an IDTSBuffer100.
公用方法 GetBLOBObject Gets an IDTSBLOBObject100 that is used to read and write the bytes in a column in an IDTSBuffer100.
公用方法 GetBLOBStream Gets an IStream interface used to access the binary large object (BLOB) stored in a column in an IDTSBuffer100.
公用方法 GetBoundaryInfo Gets the number of columns and the maximum number of rows that an IDTSBuffer100 can hold.
公用方法 GetColumnCount Gets the number of columns in an IDTSBuffer100.
公用方法 GetColumnInfo Gets the DTP_BUFFCOL structure for the specified column in an IDTSBuffer100.
公用方法 GetData Retrieves the data stored in a specified row and column of a IDTSBuffer100.
公用方法 GetDataByRef (Feature deprecated, see Remarks.) Gets a pointer to the data stored in a column in an IDTSBuffer100.
公用方法 GetFlatMemory Gets a pointer to the bytes stored by an IDTSBuffer100.
公用方法 GetID Retrieves the ID of a buffer.
公用方法 GetManager Gets a buffer manager.
公用方法 GetRowCount Gets the number of rows stored in an IDTSBuffer100.
公用方法 GetRowDataBytes (Feature deprecated, see Remarks.) Gets a pointer to the start of a row in an IDTSBuffer100.
公用方法 GetRowStarts (Feature deprecated, see Remarks.) Use the GetData or GetBLOBData method instead of the GetRowStarts method.
公用方法 GetStatus Retrieves the status information of a column in an IDTSBuffer100.
公用方法 GetType Gets the handle of a buffer type.
公用方法 IsEndOfRowset Specifies whether an IDTSBuffer100 has reached the end of its collection of rows.
公用方法 IsNull Checks whether a specified column is null.
公用方法 LockData Locks the data in an IDTSBuffer100.
公用方法 MoveRow Moves a row in an IDTSBuffer100 to a new location.
公用方法 PrepareDataStatusForInsert Sets the status value of the columns in a range of rows.
公用方法 RemoveRow Deletes a row from an IDTSBuffer100.
公用方法 ResetBLOBData Deletes the bytes stored in a column in an IDTSBuffer100.
公用方法 SetBLOBFromObject Assigns the data contained in an IDTSBLOBObject100 to a column in an IDTSBuffer100.
公用方法 SetBLOBFromStream Assigns data to a binary large object (BLOB) column from a sequential stream.
公用方法 SetData Assigns data to a column in an IDTSBuffer100.
公用方法 SetEndOfRowset Notifies an IDTSBufferManager100 that the component has finished adding rows to an output IDTSBuffer100 object.
公用方法 SetErrorInfo Sets the error information for a row.
公用方法 SetStatus Sets the status information of a column in an IDTSBuffer100.
公用方法 SwapRows Swaps the location of two rows in an IDTSBuffer100.
公用方法 UnlockData Unlocks the data in an IDTSBuffer100 object.

上層

備註

The IDTSBuffer100 is an in-memory, two-dimensional data structure that contains rows and columns. Each column in a buffer has information that describes its data type, its offset location in memory in the row, its maximum size, and the lineage ID of the column in a component.

The data in each column is accessed either by using its offset as defined by the DTP_BUFFCOL structure, or by using the SetData and GetData methods, in which the data location of the column in the buffer is defined by handles to its row and column.

There are two types of buffers, private and public, which are created by the IDTSBufferManager100. Private buffers are created when requested by a data flow component and are used internally by the component. Public buffers are provided to the components in the data flow graph and filled and manipulated before arriving at the destination. Public buffers are created, managed, and destroyed by the IDTSBufferManager100.

Buffers are identified by their handles and are 1-based, which means they cannot have a value of zero or null Nothing nullptr unit null 參考 (在 Visual Basic 中為 Nothing) unless they are invalid.

Managed component developers do not typically use the IDTSBuffer100 object unless they intend to create private buffers and implement the code necessary to interoperate between managed code and native code. Instead, they use the managed PipelineBuffer class.