Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data Import Wizard - Unexpected Unrecoverable Error Expand / Collapse
Posted Wednesday, October 24, 2012 5:43 AM


Group: General Forum Members
Last Login: Wednesday, August 10, 2016 9:04 AM
Points: 161, Visits: 677

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?
Post #1376412
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse