Posted - 11/01/2012 : 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  ).
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) returned
If 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 advance