Solved

SSIS Import and Export wizard crash when I click Edit Mappings

Posted on 2014-11-11
6
74 Views
Last Modified: 2016-02-11
Hello Experts Exchange
I am using the SSIS Import and Export wizard and every time I click on Edit Mappings the application crashes.  

I have attached a screen shot of the error.

Has anyone seen this error before?

Regards

SQLSearcher
SSIS-Error.jpg
0
Comment
Question by:SQLSearcher
  • 4
  • 2
6 Comments
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Not enough info in the image to answer the question.

Give us some details on the sources and destinations that you're trying to connect to:  SQL/Oracle/flat files, data types..
0
 

Author Comment

by:SQLSearcher
Comment Utility
Hello Jim
It looks like the problem happens whatever the sources and destinations are, I have tried excel to SQL, and SQL to SQL.

It looks like a problem with the DTSWizard.exe, but I don't know how to fix it.

Regards

SQLSearcher
0
 

Accepted Solution

by:
SQLSearcher earned 0 total points
Comment Utility
Hello Experts Exchange
I managed to get the Edit Mapping button working when I uninstalled the SQL Server service pack 2, but when I reinstalled the service pack the Edit Mapping button stopped working again.

Regards

SQLSearcher
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
I haven't experienced this before, so I don't have a good answer to give you.  Sorry.
0
 

Author Comment

by:SQLSearcher
Comment Utility
Hello Experts Exchange
Is there a way I can ask Microsoft about the problem for free?

Regards

SQLSearcher
0
 

Author Closing Comment

by:SQLSearcher
Comment Utility
Found my own answer.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now