.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

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

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
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.

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

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 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?   

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


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

RS 2008 - Ability to Export to excel/pdf

I have a report with customer details in it, i need to be able to schedule this to export into xls/pdf for each customer with the files named as <customername>. The only way i can see how to do this is to create 2 subscriptions per customer, is there a better way of achieving this?   Thanks

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

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

Text was truncated with "nvarchar(max)" data type and size by using SSIS Import and Export Wizar



I am using SSIS Import and export Wizar to load data from Excel file, I have set the datatype as "nvarchar(max); those data are not biger than 1000 bits but was failed to transfer as the error says:

[Source - TreatmentPlans$ [1]] Error: The "output column "SchoolPlan" (57)" failed because truncation occurred, and the truncation row disposition on "output column "SchoolPlan" (57)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

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

Checking Mapping -- SSIS package created Export and Import


Hi all

I created SSIS package using Import and Export,

1.some  of the reasons I what edit that Package to add more tables and modify tables names.

2.I want check the mapping Data types mached and not match(Basically I want check mapped Data types)

can body help me hwo to check the mapping and edit the ssis package


Thanks in Advance




Import and Export Data (32-bit) Wizard to Dump Data to Excel


I am trying to export some data from a simple three-column table on my SQL 2008 R2 instance to Excel 2007 (also happens in Excel 2003). Our data has a lot of foreign (Hebrew) characters on it and although the copy works ok, the data as it appears in Excel is gibberish.

The source table in SQL contains three columns:

  • smallint - numbers
  • varchar(30) - hebrew text
  • varchar(50) - hebrew text
  • varchar(15) - hebrew text

When I fire up the Import-Export wizard I see the following: http://img524.imageshack.us/img524/1830/sqltable.png. When I click on the yellow warning for a conversion problem, I see this: http://img375.imageshack.us/img375/4255/conversion.png.

Do I need to modify the core SQL or change the data type? I already tried modifying the destination datatype to be varchar instead of LongText but that didn't help.

Any assistance would be fantastic!


SSIS -2008 R2 - ODBC Connection error - Password does not save


Please know that I am new to SSIS 2008 and XML. Have a package I am trying to deploy. Am on a HV 64 Bit environment SQL Server 2K8 R2. Have an ODBC connection to our HBOC system as a data source. As always package runs in test environment and not in prod.  I need a bit of insight into the what and why's of the configuation file and how to change out the XML. 

Main issue is the password not saving and how to handle the ODBC side of things. I appreciate any help in this matter as I have searched with no real understanding of XML and best practices of creating the Congif file.


Import and Export Wizard only imports few rows from excel


When I import data using Import and Export Wizard in Visual Studio 2008 for SQL Server 2000 DB from an Excel file, it only imports few rows and not all. It happens when I am appending to an existing table. The rows that are imported have correct data as I want it to be.

It imports fine when I import to a new table, which is created while importing. Is there any way I can make the Import and Export wizard to Append all the rows from an Excel file? Is it a bug in SQL Server? I am not sure. I am using a .xls file.


SQL Management Studio 2008 R2 Export/Import color settings?


The default color settings in SSMS are pretty hard on the eye and may cause snow blindness :)


Visual studio makes it easy to do this but was unsure of how to do the same in S.S.M.S.  Is there a way to export / import color settings for S.S.M.S?




SSIS 2008 - Import all CSV files in folder - each target different table


I'm new to SSIS 2008, and I'm attempting to import a series of CSV files into a database. I want to loop over every CSV file in a specified folder and import each file into a different table that must be created on the fly (name of table should be base name of file, i.e. with path and extension stripped off). The file structures are similar, but not identical, so the single target table solution won't work.

Using an example I found here:


I'm able to successfully load all files into ONE table, but I need to load each file into a separate table. Can anyone provide some assistance on exactly how to modify the project to allow for a table to be created, on the fly, for each source file?




"SQL Server Import and Export Wizard" (SQL 2005) Excel & ISAM


When I run the “SQL Server Import and Export Wizard” (SQL 2005) on my laptop, I attempt to import an EXCEL file to a table.


If I try both Excel-2007 and Excel-2010 format files, I get the following error.


     “The operation could not be completed” “Could not find installable ISAM. (Microsoft JET Database Engine)”


Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.
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