SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Importing CSV field into database via DTS -sql2000
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

barnsley
Starting Member

26 Posts

Posted - 11/01/2012 :  09:49:32  Show Profile  Reply with Quote
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

26 Posts

Posted - 11/02/2012 :  11:55:37  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000