Multiple Source Rows > 1 Destination Row

  • I receive data from my customer like the example below. This example is a small subset of the entire file and only represents 2 records. Each row in the source file is terminated by CRLF.

    Using SSIS, can I merge 5 rows of source into 1 row of my destimation table?

    ****** TOTAL VPN ****** UDA Desc,"",LP 12619,"","","","","","","","","","","","","","","","","","",""

    5221,4,HK WRAP DRESS,8.25,F,Fashion,Units,0,0,0,0,0,0,0,0,0,0,ST,0,402,"",0

    4021,657-CERICE,"",28.00,"","",Dollars,0,0,0,0,0,0,0,0,0,0,WH,0,"",0,0

    221,657,EVY OF CALIFORNI,28.00,1,"",AvgRetl,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,IT,0,"",N,0

    HK57291,"",15736120,"",0,"",ST%,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,WOS,"","","",0

    ****** TOTAL VPN ****** UDA Desc,"","LP 12619,16518","","","","","","","","","","","","","","","","","","",""

    5221,8,SMOCKED KNIT DRE,8.25,F,Fashion,Units,13,14,16,18,11,43,43,187,1,0,ST,281,"",0,75

    4021,657-CERICE,"",28.00,"",13-MAY-10,Dollars,233,228,230,293,186,690,690,3000,28,0,WH,0,"",0,0

    221,657,EVY OF CALIFORNI,28.00,21,14-MAY-10,AvgRetl,17.92,16.29,14.38,16.28,16.91,16.05,16.05,16.04,186,0,IT,0,"",N,0

    HK57240,"",15564640,"",48.6,14,ST%,4.4,4.5,4.9,5.3,3.1,13.3,13.3,40.0,2972,0,WOS,18,"","",0

  • can u try using ScriptComponent Transformation

  • rajiv.kumarb (1/30/2012)


    can u try using ScriptComponent Transformation

    That is indeed the way to go.

    Creating an Asynchronous Transformation with the Script Component

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

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