Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS Import and Export wizard crash when I click Edit Mappings

Posted on 2014-11-11
6
Medium Priority
?
113 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 66

Expert Comment

by:Jim Horn
ID: 40435438
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
ID: 40435729
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
ID: 40437293
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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 66

Expert Comment

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

Author Comment

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

Regards

SQLSearcher
0
 

Author Closing Comment

by:SQLSearcher
ID: 40784714
Found my own answer.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

916 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