Normalizing record using DTS

[DSJ1967]

I have an incoming text file that is in the format of

CustomerId|Product1 Sales|Product1 Share of Sales|Product2 Sales|Product2 Share of Sales| ...

which continues on for about 15 products. The product names are actually in the column names. I need to normalize this into

CustomerId|Product1Sales|Product1 Share
CustomerId|Product2Sales|Product2 Share
.
.
.

I am sure that I must be able to do this through DTS but am not sure where to begin.

Any help would be appreciated.

Cheers

 

[nigelrivett]

Most flexible to load into a staging table then split up the records from there

see

http://www.nigelrivett.net/ImportTextFiles.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.