Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ScriptComponent.ProcessInput Method (Int32, PipelineBuffer)

Processes the inputs in Script components, such as transformations and destinations, that receive inputs from upstream components.

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.TxScript (in Microsoft.SqlServer.TxScript.dll)
public virtual void ProcessInput(
	int InputID,
	PipelineBuffer buffer
)

Parameters

InputID
Type: System.Int32
The ID of the input to process.
buffer
Type: Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer
A PipelineBuffer that contains the input rows.

The Script component developer does not use the ScriptComponent class directly, but indirectly, by coding the methods and properties of the ScriptMain class, which inherits from ScriptComponent through the UserComponent class.

Although the developer can override the ProcessInput method, it is usually sufficient to override the <InputBufferX>_ProcessInputRows method in the ScriptMain class to process data from the input buffers. When additional processing is required, it may be preferable to override the <InputBufferX>_ProcessInput method.

The following code sample from the autogenerated ComponentWrapper project item shows how the Script component uses the ProcessInput method.

    Public Overridable Sub Input0_ProcessInput(ByVal Buffer As Input0Buffer)

        While Buffer.NextRow()
            Input0_ProcessInputRow(Buffer)
        End While

    End Sub
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.