Data Import Wizard - Unexpected Unrecoverable Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Data Import Wizard - Unexpected Unrecoverable...

Data Import Wizard - Unexpected Unrecoverable Error

Rate Topic

Display Mode

Topic Options

Author

Message

terry999

Posted Wednesday, October 24, 2012 5:43 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 10:19 AM
Points: 68, Visits: 266

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

[url=http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e8be2b2a-57f9-485e-90df-2f857f3a0c55][/url]

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 »

Permissions