Called at run time when a PipelineBuffer from an upstream component is available to the component to let the component process the incoming rows.
Assembly: Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)
'Declaration Public Overridable Sub ProcessInput ( _ inputID As Integer, _ buffer As PipelineBuffer _ ) 'Usage Dim instance As PipelineComponent Dim inputID As Integer Dim buffer As PipelineBuffer instance.ProcessInput(inputID, buffer)
The method is called to provide the component a full PipelineBuffer object that contains rows from the upstream component. The columns contained in buffer include those columns defined in the IDTSInputColumnCollection100 of the component. If the component has synchronous outputs, the buffer will also include the columns added to the output column collection by the component, and all the columns in the output column collection of the components upstream from the component. Columns are located in a buffer row using the FindColumnByLineageID method of the BufferManager.
will be called repeatedly as the data flow task receives full buffers from the upstream components. The method is called until the EndOfRowset property is true.
// Do something with each row.
// Optionally, do something after all rows have been processed.