DBF to SQL on daily basics

• gilberto.henriquez

  SSC Rookie

  Points: 40

  More actions

  January 19, 2013 at 7:45 am

  #287824

  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.

• prvmine

  SSCertifiable

  Points: 7022

  More actions

  January 19, 2013 at 8:22 am

  #1578963

  try this

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

• gilberto.henriquez

  SSC Rookie

  Points: 40

  More actions

  January 19, 2013 at 9:22 pm

  #1579008

  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.