Solved

SSIS Import and Export wizard crash when I click Edit Mappings

Posted on 2014-11-11
6
99 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

623 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