SQL Server Import/Export Wizard Crashes

Whenever I try to import or export data using SQL Server Import And Export Wizard, everything is great until I click on the “Finish” button. 

The wizard gets to the “Setting Source Connection” step and at 0% complete, I get the message “SQL Server Import and Export Wizard Has Encountered A Problem And Needs To Close.”  This happens every time I run the Wizard, whether it be from SSMS, BIDS,
or the file manager.  It doesn’t matter what type of database table/file I import to or export from.

If I select to Debug, I get this message:  “Windows Has Triggered A Breakpoint In DTSWizard.exe.  This may be due to a corruption of the heap, and indicates a bug in DTSWizard.exe or any of the DLL’s it has loaded.  The output window may have
more diagnostic information.”  Here is the output:

'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32ntdll.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32mscoree.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32kernel32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32advapi32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32rpcrt4.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32secur32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32shlwapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32gdi32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32user32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32msvcrt.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32imm32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorwks.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSWinSxSx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4027_x-ww_e69378d0msvcr80.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32shell32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSWinSxSx86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_x-ww_D8713E55comctl32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32mscorlib6d667f19d687361886990f3ca0f49816mscorlib.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorsec.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32wintrust.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32crypt32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32msasn1.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32imagehlp.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSWinSxSx86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_5.82.3790.3959_x-ww_78FCF8D0comctl32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32rsaenh.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32psapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32userenv.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32version.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32netapi32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32cryptnet.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32wldap32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32sensapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32ole32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32MSCTF.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System80978a322d7dd39f0a71be1251ae395aSystem.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32DTSWizarde2941a737b5d3c3b32d77cb8286de105DTSWizard.ni.exe', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#c4ffffb990dd9eba47fbd1bcb23217c4Microsoft.SqlServer.WizardFramework.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.Drawing3da96ee075bab9202626ae44c18d226cSystem.Drawing.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.Windows.Forms63406259e94d5c0ff5b79401dfe113ceSystem.Windows.Forms.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.NetEnterp#ab0fa478df45e38225090c1deff0e6fdMicrosoft.NetEnterpriseServers.ExceptionMessageBox.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSWinSxSx86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.6001.22319_x-ww_F0B4C2DFGdiPlus.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32apphelp.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32MSCTFIME.IME', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#ed8ccc800ee6aebaaa48658a069f8bd5Microsoft.SqlServer.GridControl.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32oleaut32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32riched20.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#1ec730e23db49ca63c90628646a31b8eMicrosoft.SqlServer.DTSRuntimeWrap.ni.dll', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#be97259b86823ebc68d70eabfd6de030Microsoft.SqlServer.DTSPipelineWrap.ni.dll', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32clbcatq.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32comres.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32xpsp2res.dll', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server90DTSBinnDTS.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSWinSxSx86_Microsoft.VC80.ATL_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_cbb27474ATL80.dll', Symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSWinSxSx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4027_x-ww_e69378d0msvcp80.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server90DTSBinndtsmsg.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32sxs.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipeline.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32msi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32mslbui.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#5f191a0a1898e6a24c126ae4a7110472Microsoft.SqlServer.CustomControls.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server80ToolsbinnDTSFFile.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server80ToolsbinnResources1033DTSFFile.RLL', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server80ToolsbinnDTSPump.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server80ToolsbinnResources1033DTSPump.RLL', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:Program FilesCommon FilesSystemOle DBoledb32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32msdart.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesCommon FilesSystemOle DBoledb32r.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesCommon FilesSystemmsadcmsadce.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesCommon FilesSystemmsadcmsadcer.dll', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32odbc32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32comdlg32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32odbcint.dll', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.Datac70731047b0022638b3f9fb158948a03System.Data.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32ws2_32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32ws2help.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.Xml773a9786013451d3baaeff003dc4230fSystem.Xml.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.Configurationb82c00e2d24305ad6cb08556e3779b75System.Configuration.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32CustomMarshalers9bea05938bee3555c5aa8763d89a68f9CustomMarshalers.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyGAC_32CustomMarshalers2.0.0.0__b03f5f7f11d50a3aCustomMarshalers.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.DataTrans#5a658203909b1c7079f4eedd8e2487b3Microsoft.DataTransformationServices.Controls.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.Transactions5a555c9ae6984c40157cf940bb519f7cSystem.Transactions.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyGAC_32System.Transactions2.0.0.0__b77a5c561934e089System.Transactions.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32comsvcs.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32sqlncli.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32sqlnclir.rll', Binary was not built with debug information.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32kerberos.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32cryptdll.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32msv1_0.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32iphlpapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32ntdsapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32dnsapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32security.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32schannel.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server90Sharedinstapi.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSsystem32dssenh.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.EnterpriseSe#4267bd908175603006c6c90bb5d900c7System.EnterpriseServices.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32System.EnterpriseSe#4267bd908175603006c6c90bb5d900c7System.EnterpriseServices.Wrapper.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.Wrapper.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#b5d73d4113e5d52e355f100eea0b9bb6Microsoft.SqlServer.SqlTDiagM.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#cefbcad93f77106cb572b0346ba68cabMicrosoft.SqlServer.ManagedDTS.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#3bd6e45dfd38431973acd49d2ce9509dMicrosoft.SqlServer.ConnectionInfo.ni.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:Program FilesMicrosoft SQL Server90DTSBinnDtsConn.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:WINDOWSassemblyNativeImages_v2.0.50727_32Microsoft.SqlServer#1a39da427a326273c5fc7c3e1596e80Microsoft.SqlServer.SQLTask.ni.dll', No symbols loaded.
Windows has triggered a breakpoint in DTSWizard.exe.

This may be due to a corruption of the heap, and indicates a bug in DTSWizard.exe or any of the DLLs it has loaded.

The output window may have more diagnostic information

 

This error message is created in the Event Viewer:

Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 1023
Date:  10/5/2010
Time:  11:37:30 AM
User:  N/A
Computer: FSCORP2
Description:
.NET Runtime version 2.0.50727.3082 - Fatal Execution Engine Error (7A0979C6) (80131506)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

I uninstalled .NET Framework 3.5 SP1, .NET Framework 3.0 Service Pack 2, and .NET Framework 2.0 Service Pack 2 and then reinstalled .NET Framework 3.5 SP1 and I’m still getting the errors.

I’m running SQL Server 2005 Developer Edition on Windows Server 2003 version 5.2. 

We upgraded from SQL Server 2000.  The data import/export worked fine in the 2000 version but it hasn’t worked since we upgraded to 2005.  We don’t have any DTS packages.

Does anyone have any ideas about this?  Thank you for your help.

 

you didn’t see any error message  in final step  ( I mean after click  on Finish button  and failed the wizard, you may see a link to see error message ), If you see that paste error here/