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 |
|
barnsley
Starting Member
34 Posts |
 Posted - 2012-11-01 : 09:49:32
|
| I would like to import the entire contents of 1 field from about 100 csv files and place the data into a database table.I am using a DTS package.The files are all csv - (Microsoft Excel CSV file [2010] ).I am not sure what driver to select in 'create new data source'?In the list there are options like:Driver da Microsoft para arquivos text0 (*.txt;*.csv)Driver do Microsoft Excel (*.xls)Microsoft Text Driver (*.txt;*.csv)When I select any of the .csv or xls driver data sources - I get an error: hresult of 0x80004005 (-2147467259) returnedIf I select text file source from Connection >> Other Connection, I can browse for a csv file, but when I then add a 'execute sql task' I am not allowed to enter a sql script to insert the column required.- not sure which connection and procedure/task i need to execute here?thanks in advancemark. |
|
|
barnsley
Starting Member
34 Posts |
Posted - 2012-11-02 : 11:55:37
|
| This bit is now working - I use 'TextFile (source} 'for the import bit and a regular db sql server connectionmark. |
 |
|
|
|
|
|
Importing CSV field into database via DTS -sql2000