Geeks With Blogs
Dan Krueger If you dream it, I build it...

Problem: For the last few months I have been running the SSIS Import/Export Wizard and it has been throwing up an "Unexpected Unrecoverable Error". The three buttons – Abort, Retry and Ignore – all cause the wizard to close. I am running SQL Management Studio 2008 R2 on my Windows 7 x86 computer. This would happen sporadically but consistently when I would try to save the SSIS package or when I would try to display an error message.

Solution: Edit the file "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe.config" (run Notepad, etc. as Administrator), and comment out/delete <supportedRuntime version="v4.0"/>. Leave the line about v2.0.50727 alone. I'm now getting proper error messages instead of outright program crashes, which is nice if you don't want to have to completely set up the import again after it crashes trying to notify you of a primary key violation or something.

Posted on Tuesday, November 16, 2010 1:04 PM | Back to top


Comments on this post: SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"

# re: SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"
Requesting Gravatar...
On some systems the path will be...
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe.config
Left by Tekretic on Nov 21, 2010 5:19 PM

Your comment:
 (will show your gravatar)


Copyright © Dan Krueger | Powered by: GeeksWithBlogs.net