Post reply

adding row to pipeline

  • December 18, 2007 at 12:53 pm

    #122764

    In the ssis package I run the data through a script transformation object to clean up and format some of the data prior to importing. My issue is the invoice field in the input data, it may have 2 invoices separated by a "/". Is it possible to take all the fields in the current row plus the second invoice number and create a new row and pass it on to the pipeline

  • December 19, 2007 at 2:10 am

    #761308

    Yes, but SynchronusOutputId property for given output of this task should be set to none. Then counts of input and output rows can differ.

  • December 26, 2007 at 11:28 am

    #762758

    Thank you, now the question. I am doing some data conversion in a script. How can I add the new row to the pipeline. example

    col 1 col 2 col3 col4

    test test test1\test2 December

    Desired output to be sent on.

    test,test,test1,december

    test,test,test2,december

    Thanks again

  • December 27, 2007 at 5:10 am

    #762897

    Here it is:

    Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

    '

    ' Add your code here

    '

    Dim a() As String

    Dim item As String

    a = Row.Col3.Split("\"c)

    Dim i As Integer

    For i = 0 To a.Length - 1

    Output0Buffer.AddRow()

    Output0Buffer.Col1 = Row.Col1

    Output0Buffer.Col2 = Row.Col2

    Output0Buffer.Col3 = a(i)

    Output0Buffer.Col4 = Row.Col4

    Next

    End Sub

  • December 27, 2007 at 8:31 am

    #762960

    Thank you for the reply. It worked

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply