Reply
Wed 19 Nov, 2014 12:45 pm
I have a flat file with parent child records parent record is identified by 01 and child records from 02 to 16. here is the layout.
010101ABC0001230412192L 01.... Parent1
02NAME...ADDRESS....01256389201419... CHILD1
03NAME...ADDRESS....01256389201419... CHILD2
010101ABC0001230412192L 01.... Parent2
02NAME...ADDRESS....01256389201419... CHILD1
03NAME...ADDRESS....01256389201419... CHILD2
04NAME...ADDRESS....01256389201419... CHILD3
and this is how I want it:
010101ABC0001230412192L 01…02NAME...ADDRESS....01256389201419
010101ABC0001230412192L 01.. 03NAME...ADDRESS....01256389201419
u sing C# in ssis