January 19, 2013 at 7:45 am
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.
January 19, 2013 at 8:22 am
January 19, 2013 at 9:22 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply