SSIS Script Component Transformation

Hi,
a script transformation can do this but you have to do some configuration (as the default settings would not allow this).
Just configure your Output (Script Transformation Editor -> Inputs and Outputs) and set "SynchronousInputID" to "None" and add columns to your output like "KeyFieldOut", "Field1","Field2" ...

Then you can simply use this in your script:

public override void Input0_ProcessInputRow(Input0Buffer Row)
    {
        string[] separator = { "|" };
        string[] splittedLine = Row.Line.Split(separator, StringSplitOptions.None);
        OutputSplittedBuffer.AddRow();
        OutputSplittedBuffer.KeyFieldOut = Row.KeyField;
        OutputSplittedBuffer.Field1 = splittedLine[0];
        OutputSplittedBuffer.Field2 = splittedLine[1];
    }

Select allOpen in new window

HTH
Rainer

I'm not sure how to implement your code into my script. My script is below:

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
        Dim keyField As Integer = Row.KeyField
        Dim itemList As String = Row.Line
        Dim delimiter As String = "|"

        If Not (String.IsNullOrEmpty(itemList)) Then

            Dim inputListArray() As String = _
                itemList.Split(New String() {delimiter}, _
                StringSplitOptions.RemoveEmptyEntries)

            For Each item As String In inputListArray
                With Output0Buffer
                    .AddRow()
                    .KeyField = keyField
                    .ClaimNumber = item
                   
                End With
            Next

        End If

    End Sub

I have found an alternative solution.