Post reply

dbf file import into sql table-set up connection

  • May 9, 2006 at 12:34 pm

    #114629

    I tried to set up data transformation service import the .dbf file into the MS SQL database. Any one know what drive I should use ? I tried to use MS Foxpro drive. then it will ask me for dsn, I set that up then will get me the error fox pro 2.6 did not support that any more. and prompt for MS Visual Fox pro drive. I can't set up connection at all. Thanks.

  • May 10, 2006 at 9:05 am

    #637024

    Try downloading the latest OLEDB for FoxPro. It should be @ the http://www.microsoft.com/downloads site.

    I was able to use that to import Foxpro data on my machine. SP1 for SSIS apparently added a bug in dealing with Foxpro files and databases through the wizard, but it still seems to work through BIDS.

    -Pete

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply