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.
| Author |
Topic |
|
chicosqlhack
Starting Member
4 Posts |
 Posted - 2004-02-25 : 19:34:53
|
| I am attempting to import several hundered .csv files into a sql database using dts. dts is assuming the first line of the .csv is headers when in fact the first line is data. how do i get dts to recognize first line as data? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-25 : 19:59:31
|
| In the properties of the source connection, uncheck the "first row has column names" option.Tara |
 |
|
|
|
|
|
dts treats first row of .csv file as header