Data Import Wizard - Unexpected Unrecoverable Error

• terry999

  SSCertifiable

  Points: 5033

  More actions

  October 24, 2012 at 5:43 am

  #265968

  Hi

  I'm trying to use the VFP OLEDB driver on windows 7 machine with SQL2005 and SQL2008 with the Import data wizard. I have .Net 4, extended and client installed

  Both versions correctly import from Excel and text files

  When I choose VFPOLEDB driver and click properties button I get

  "Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore

  From the internet I've found that there is a problem with

  C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe.config

  I've removed the .NET 4.0 entry and just have the .NET 2 entry in DTSWizard.exe.config.

  I've reinstalled .Net 4 as well.

  I wouldn't mind using ODBC either but import wizard only shows OLEDB connections.

  I've created an SIS package that uses the VFPOLEDB driver, not without its problems (memory leaks I think) but for my basic use worked.

  However I really a point and click way of importing dbf files, its no tproduction code just ad-hoc work.

  There is no C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe.config so what does SQl2005 use?