adding row to pipeline

Question

adding row to pipeline

rmellnick-582923

SSC Journeyman

Points: 86
More actions
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

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

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

Powichrowski Marek Hall of Fame Points: 3483 More actions · Answer 1

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

rmellnick-582923 SSC Journeyman Points: 86 More actions · Answer 2

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

Powichrowski Marek Hall of Fame Points: 3483 More actions · Answer 3

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

rmellnick-582923 SSC Journeyman Points: 86 More actions · Answer 4

rmellnick-582923

SSC Journeyman

Points: 86

December 27, 2007 at 8:31 am

#762960

Thank you for the reply. It worked