DBF to SQL on daily basics

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » DBF to SQL on daily basics

DBF to SQL on daily basics

Rate Topic

Display Mode

Topic Options

Author

Message

gilberto.henriquez

Posted Saturday, January 19, 2013 7:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:07 PM
Points: 2, Visits: 28

Hello,
I need to import to my SQL server database information from DBF files every day,
to do this I was trying to set up an SSIS package to import from those DBF files
I was able to get connection to the files using Jet 4.0 drivers adding DBASE 5.0 as parameters
and test connection is OK (successfully)

but I am unable to get data from those tables, everytime I choose a table and try to preview it or see columns, I got errors.

As far as I can read it seems like there is some kind of uncompatibility, since my server is 64 bits and I am running the packages from that server and the drivers are not totally ok.

I also try changing the package behavior to be 32 bits, but still got same errors.

Please share with me the best way to do this, since I should get 3 different dbf files every day, so the table name (name of the file) will be different always, so I also need to set it up as parameter.

Post #1409198

prvmine

Posted Saturday, January 19, 2013 8:22 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:40 PM
Points: 1,761, Visits: 3,652

try this

http://www.mssqltips.com/sqlservertip/2463/importing-dbf-files-into-sql-server/

Post #1409200

gilberto.henriquez

Posted Saturday, January 19, 2013 9:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:07 PM
Points: 2, Visits: 28

Hi and thank you.

I already try that option and I was unable to pass the step of the error (after putting the advance properties dBase 5.0) thats the correct version and it is not accepted.

I also try dbase IV and dbase III, but same error.

Post #1409253

« Prev Topic | Next Topic »

Permissions