Represents an in-memory, two-dimensional storage object that contains rows and columns.
Assembly: Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)
Thetype exposes the following members.
|AddBLOBData||Appends byte data to a column in an .|
|AddRow||Adds a new row to an object.|
|Clone||Creates a private copy of an object.|
|DirectErrorRow||Sends a row in an object to an IDTSOutput100 whose IsErrorOut property is true.|
|DirectRow||Sends a row in an to an IDTSOutput100.|
|GetBLOBData||Retrieves an array of bytes from a binary large object (BLOB) stored in a column of a .|
|GetBLOBLength||Gets the number of bytes contained in a column in an .|
|GetBLOBObject||Gets an IDTSBLOBObject100 that is used to read and write the bytes in a column in an .|
|GetBLOBStream||Gets an interface used to access the binary large object (BLOB) stored in a column in an .|
|GetBoundaryInfo||Gets the number of columns and the maximum number of rows that an can hold.|
|GetColumnCount||Gets the number of columns in an .|
|GetColumnInfo||Gets the DTP_BUFFCOL structure for the specified column in an .|
|GetData||Retrieves the data stored in a specified row and column of a .|
|GetDataByRef||(Feature deprecated, see Remarks.) Gets a pointer to the data stored in a column in an .|
|GetFlatMemory||Gets a pointer to the bytes stored by an .|
|GetID||Retrieves the ID of a buffer.|
|GetManager||Gets a buffer manager.|
|GetRowCount||Gets the number of rows stored in an .|
|GetRowDataBytes||(Feature deprecated, see Remarks.) Gets a pointer to the start of a row in an .|
|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 .|
|GetType||Gets the handle of a buffer type.|
|IsEndOfRowset||Specifies whether an has reached the end of its collection of rows.|
|IsNull||Checks whether a specified column is null.|
|LockData||Locks the data in an .|
|MoveRow||Moves a row in an to a new location.|
|PrepareDataStatusForInsert||Sets the status value of the columns in a range of rows.|
|RemoveRow||Deletes a row from an .|
|ResetBLOBData||Deletes the bytes stored in a column in an .|
|SetBLOBFromObject||Assigns the data contained in an IDTSBLOBObject100 to a column in an .|
|SetBLOBFromStream||Assigns data to a binary large object (BLOB) column from a sequential stream.|
|SetData||Assigns data to a column in an .|
|SetEndOfRowset||Notifies an IDTSBufferManager100 that the component has finished adding rows to an output object.|
|SetErrorInfo||Sets the error information for a row.|
|SetStatus||Sets the status information of a column in an .|
|SwapRows||Swaps the location of two rows in an .|
|UnlockData||Unlocks the data in an object.|
The 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 unless they are invalid.
Managed component developers do not typically use the 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.