Insert multiple columns into one using bulk upload
Posted on 2008-11-03
I have 20 columns of data in csv format that currently go into 20 columns however I also want them all to go into one column as well using bulk upload and a DTS package / statement.
The following data - 1,2,3,4,5,6,7,8,9,1,2,3,4,5,6,7,8,9,1,2 - currently goes into 20 different columns. I want it now to go into one but not so that it is in the one cell seperated by commas but as
with an identifier from the csv file also in each row e.g.
Any idea how this could be done?