Add New record

[scottsanpedro]

Hi..New to SSIS.
I have a flat file that has two fields. One is productcode, one is quantity.
All I want to do is if productcode = 'GM-Hello-1' then I want to add another line that says 'GM-Hello-2'with a quantity.
Its because the two products are in a pack but only one is added to the order.
Many thanks in advance
Scott

 

[MDXer]

Without really sitting down and working the issue through my first answer would be to do the following.

Custom Script task as a transform. Within the task compare you product code. If the product code = 'GM-Hello-1' then add a new row to the output buffer which is 'GM-Hello-2'.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[scottsanpedro]

Thanks Paul....
Just needed a nudge in the right direction. Wasn't sure if a transform was there to do this.
Cheers
Scott