January 30, 2012 at 10:52 am
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
January 30, 2012 at 11:46 pm
can u try using ScriptComponent Transformation
January 31, 2012 at 12:46 am
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