.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

import/export wizard crashes on SQL Express 2008 R2 installed on Windows 7 (32-bit)

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I have been getting "Unexpected Unrecoverable Error; Abort, Retry, Ignore" when using the SQL Import/Export Wizard in the following scenarios (these are the only two ways I have tried using the Wizard):

1) Source Advantage OLE DB Provider, destination SQL Server, copy tables

2) Source Microsoft Excel, destination SQL Server, copy tables, show report if there were any failures

I have run the SQL Setup Repair and still get the same behavior.  Are there known issues with SQL Express 2008 R2 on Windows 7 for Import/Export?

Thanks, David

View Complete Post

More Related Resource Links

sql server 2008 import/export wizard... completely useless??



import/export wizard in 2000 had lots of options.

I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.

Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.

"Copy database.." is not an option here: it needs sysadmin on both source and destination server.

Re-adding the constraints manually is not an option either: the database is WAY too large. 

I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.

Googling, I found I am not alone:


This post is exactly my situation. Here's what his post says: (bolded key parts)


I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy.

Firstly I created a new empty db on the local machine. Then I scripted the structure of the db on the remote machine and ran the resulting query on the local machin

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 Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\mscoree.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\advapi32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\rpcrt4.dll', No

Upgrade to SQL 2008 RS lost SSIS and ability to save Export/Import Wizard

About a month ago I upgraded from SQL Server 2005 Express to SQL Server 2008 R2.  The platform is a 2003 Server.  All was working well for about 3 weeks when last week I knoticed that I was unable to save an Import/Export Wizard that I just set up and opening up SSIS is no longer an option.  Should I simply re-install the software?  Any reason as to why it should have happened?  I deleted the installation of SQL Server Express 2005 after I sucessfully installed SQL Server 2008 R2.

Sql Server 2008 import and export wizard is failing


Sql Server 2008 import and export wizard is failing with the message: \


The ‘DbProviderFactories’ section can only appear once per config file. (System.Configuration)

This wizard will close because it encountered the following error: (Microsoft SQL Server)


This happens when I hit the “Next” button on the initial import/export wizard startup screen.


The detailed error message is below.  Any ideas on the location of the configuration file that the change needs to be made to?   

SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"

For whatever reason, whenever the SSIS Import/Export Wizard needs to display an error message, it throws up "Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore - all cause the wizard to close. I see some activity in Process Monitor that looks like DTSWizard.exe is probing around for some System.Web assemblies, and not finding them. I'm running 2008 SP1 on Win 7 x86, and I've reinstalled the client tools and Integration Services. Anybody else seen this issue? Should I file a report on Connect?

SQL express 2008 r2 on windows server 2003

install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

Import Excel data into SQL Server express 2008

I have recently installed SQL express 08 and created a table to import excel data into.  Im running on a windows 7 64 bit OS i5 processor.  I've disabled the firewall (temporarily) and will set the necessary ports once this is working. I run the following query:  (which i found from multiple sources on the net) Select   * From OPENROWSET ( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users\Public\lenovoBkup\contacts\outlookFiles\noib2a.xls', 'Select * From [sheet1$]' )  and receive the following message: Msg 7308, Level 16, State 1, Line 1                                                                                  OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.  (how did they know i was single and living in an apartment? lol) so after research of the following message i restarted the system and relaunched man

Windows 7, SQL Server 2008 Express & VWD 2008 Express Setup Problems

Hi I have Windows 7 Home Premium, and Visual Web Developer Express 2008 (which came with SP1) installed. SQL Server 2008 Express never worked - Windows 7 won't allow the Management Studio to be installed and VWD was asking for SQL Server 2005.  Looking on the web, I found advice to try the 32 bit version of SQL Server instead.  This would work with VWD, apparently.  I referred to these instructions (http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm) and used the latest links and instructions, but I could not install SQL Server at all - apparently something to do with WOW64... This has been going on for a WHILE and I'm going nuts.  I am reluctant to uninstall VWD and start again, because I had to manually fix a few things, and now it's working...  PLEASE can someone tell me of a working configuration, I have read SO MUCH advice on this, and none works, including those release notes (unless I missed something) :(

how can i export/import maintenance plans from 2005 to 2008?

I have this link http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html However, it is not the solution for me. When I expand SERVERNAME (Integration Services), all I can see it is Running packages and Stored packages, and I cannot expand any deeper. And the scripting way which described in the link above, seems is not finished. It just tells you about the select...JulieShop

Error when running configuration wizard for sharepoint 2007 on windows 2008 r2

I am trying to install sharepoint 2007 on windows 2008 r2,the setup file ran ok but when I ran the configuration wizard I received this error "Failed to start the database service MSSQL$OfficeServers. Repair this product
by selecting it from the Add/Remove Programs menu."

SQL Express 2008 install error 84B40000 "The Windows account somain/user does not exist and cannot b


Full reported error

StdOut -2068578304: The following error occurred:
The Windows account doman\user does not exist and cannot be provisioned as a SQL system administrator
Error result: -2068578304
Result facility code: 1204
Result error code: 0

domain/user is a domain administrator and also a local administrator and is the currently logged in user.  This failure is happening as part of A Citrix XenApp 6.0 configuration which was started as an Administrator

A Google search for
"The Windows account" "does not exist and cannot be provisioned as a SQL system administrator"
Came up with absolutely nothing.

A Google search for -2068578304 failed to find anything, which did not surprise me.

-2068578304 translates into hex as 84B40000.

A Google search for 84B40000

Comes up with a fair few different textual descriptions with the same error code, which I am wading through.

Any help would be welcome.  I am also asking my friends at Citrix.


With thanks in advance.


Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns



I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.



Remove SQL Server 2008 R2 Express Edition from Windows 7 professional


Are there any good practices to follow in order to remove/uninstall SQL Server 2008 R2 Express Edition from Windows 7 professional laptop? Thanks for your comments.




Detect SQL Express 2008 installed on machine


Hello all,

How cal I detect if SQL Express is installed on may machine through C#.





Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.

Windows 7 x64, SQL Express 2008 - Problems attach Northwind database

I've attached Northwind many times before, but seem to be unable to do so in Windows 7. I tried attaching from Visual Studio, using osql, and finally (after many hours) installed SQL Express 2008 / SQL Management Express 2008. All methods failed. The last failure (using SME 2008 Attach Databases) is sometimes:

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\northwnd.mdf". Operating system error 2: "2(failed to retrieve text for this error. Reason: 15105)". (.Net SqlClient Data Provider)

and other times:

Database 'Northwind' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

I have, of course, verified countless times that the files are NOT read-only.

Could any please explain what could be happening here? All suggestions much appreciated.

many thanks,


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend