SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"
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.
Fonte: http://geekswithblogs.net/dankrueger/archive/2010/11/16/ssis-importexport-wizard-unexpected-unrecoverable-error.aspx
Nenhum comentário:
Postar um comentário