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)
 Importing CSV field into database via DTS -sql2000

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) 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

mark.

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 connection

mark.
Go to Top of Page
   

- Advertisement -