Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Too Many Columns

Author  Topic 

aar2222
Starting Member

1 Post

Posted - 2008-08-20 : 11:57:03
I am trying to load a CSV file with some 2,000 columns. There is no unique row identifier native to the file. I would like to import chunks of columns into separate tables and generate a unique ID that links rows across tables. What is the best way to do this?
Thanks,
Adam

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-29 : 10:01:33
Use a format file.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -