"Unexpected Unrecoverable Error" in SQL Server 2008 R2 Import/Export Wizard

mtuepker
mtuepker used Ask the Experts™
on
Just upgraded the tools on my workstation to SS 2008 R2 from SS 2008, and now when I attempt to export to a flat file via the import/export wizard, I receive the following error referenced in the title and at the point you can see in the picture.  Any one else have this issue?  
Untitled.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Marten RuneSQL Expert/Infrastructure Architect

Commented:
Unistall klient tools completely and then install, not upgrade the SS 2008 R2 tools.

Regards Marten

Author

Commented:
I went back and uninstalled everything SQL Server 2008 R2 and reinstalled, same thing.  

Commented:
I have the same problem.  I never attempted an upgrade, but instead uninstalled and then installed the R2 RTM version.  I before putting in R2 RTM, I had been using a preview with no problem.  Then one day it broke.  That's when I put in the RTM version, but wizard still gives me the same error.  By the way, I am getting the error on Import, have not tried export.

Author

Commented:
Well, I feel better knowing that Im not alone, but kind of scared I cant find anything on MS's site, google or here for a resolution.

Commented:
I was very surprised to see that there is basically nothing out there on this issue.  Does anyone have an answer?

I had the same issue today. I'm using Windows 7 and my colleague is using XP SP3 with no problem. It was by stroke of luck that I decided to have a look at DTSWizard.exe.config. Inside there was two entries under runtime support. I believe one is pointing to .Net Framework 4 and the other 2. I deleted the entry for .net framework 4 hoping that DTSWizard will use .Net Framework version 2. It work for me. The DTSWizard.exe.config is in the same directory with DTSWIzard.exe

Author

Commented:
Just worked for me as well Taran.  I wish there was a way I could give you more than 500 points!

Thanks!
I got more than 500 points when I solve the issue for myself.
:P

By the way I had .net framework version 4.something installed in my Windows 7. I modified the entry to match the version. It did not work. So I stick with my original solution.

Author

Commented:
Its odd, my coworker has Window 7 that had SS 2008 on it and we upgraded it to SS 2008 R2 and he has had no problems.  I'll have to go check and see what his config file shows.
Do help me check if he had the exact .net framework version 4.0 installed. You can check the Microsoft .Net directory in windows. I suspect the DTSWizard.exe need that.

Author

Commented:
Just went and looked on his laptop, he doesnt have 4.0.  The most recent is 3.5.

In his config files, he also shows the 4.0 and the 2.X.  His has worked without any problems.
Maybe that's why. He does not have .net framework 4 installed. Do you have it on your Windows 7? I have version 4 something.

Author

Commented:
I have version v4.0.30319 installed on win 7.  
Hey. Same as mine. So I take it DTSWizard tried to use our version 4 .net and it did not work. Thanks.

Commented:
BlackTaran, you are a genius!  Your fix solved my problem.  Wonder why MSFT doesn't have anything in the knowledge base.

I am new to this board, so how do I give you points?  I was very skeptical of this board, thinking it couldn't have anything that wasn't available other places, but I have changed my mind.

Thanks,

Bill

P.S.  I have Win 7, 64bit.  Noticed that I had the config file in \Program Files AND \Program Files(x86).  Things diid not change for the better until I fixed the file in the (x86) directory.  Does that mean I have some kind of messed up install where I am using some 64 bit stuff and some 32 bit stuff for SQL Server?
Thanks. This thread was the only place that appear in google for this issue. When I managed to fix it I just had to share it to see if it really was the solution.

I think DTSWizard.exe does not have a 64 bit version even for 2008. It is running in 32 bit mode for 64 bit. I might be wrong though.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial