Search

Enable Undo in SSIS package designer by Simon Sabin

Closed
as Fixed Help for as Fixed

40
0
Sign in
to vote
Type: Bug
ID: 308794
Opened: 11/6/2007 7:00:51 AM
Access Restriction: Public
0
Workaround(s)
17
User(s) can reproduce this bug
Enable Undo in SSIS package designer, just like every other application available today.
Details (expand)
Product Language
English

Version

SQL Server 2008 July CTP

Category

Integration Services (DTS)

Operating System

Windows Vista
Operating System Language
English
Steps to Reproduce
Create a package
Make a change
Click undo or CTRL + Z
Actual Results
Nothing happens
Expected Results
The change is undone so you can correct mistakes

Platform

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by David W Wright on 11/20/2011 at 9:55 AM
This has been closed as "fixed". What version is it fixed in? Is there an update to fix it in SSIS 2008?
Posted by harshilsurti555 on 5/5/2010 at 6:00 AM
Every time I think I made a mistake in designing in SSIS, my hands go to Ctrl-Z and then I remember that - Oh - SSIS still doesn't support Undo!! Strange.. I thought 2008 may be having Undo, but to my disappointment, it doesn't. A designer should have Undo. Is it so difficult to do so. I guess Microsoft can easily implement by Undoing and Redoing the XML Code Behind of the DTSX. But every time the user does that, the package would need to Reload (especially a complex one) - I think that may take time and that may be the reason Microsoft avoided Undo in SSIS.
Posted by David W Wright on 1/17/2010 at 2:59 AM
Here we are in 2010 and still no resolution to this problem.

Here is another use case -
1 - Design a complex package in SSIS, with all the task boxes laid out roughly how you want them.
2 - Select Format | Auto Layout | Diagram to try to lay the boxes out better
3 - Oh No! I don't like that at all!
4 - Undo. Whoops, THERE IS NO UNDO.

Come on guys, Access 2 had undo for its layouts about 18 years ago, (IIRR it was one of the improvements over Access 1). It's not some new feature nobody thought of before!
Posted by M.Glenn on 5/27/2008 at 8:15 AM
Even if Microsoft can't provide universal undo in the designer, at the very least provide the ability to undo format changes. A couple of format selections--such as auto format or accidentally selecting "make equal" for horizontal spacing when your tasks are aligned vertically inside a sequence container--produce results that are so bad they could almost qualify as malicious. Adjacent containers get combined/scrambled. It's a real mess. It's amazing how this kind of behavior could make it into a release version. And the lack of undo functionality on top of that is the kind of thing that can turn SSIS technology evangelists within an organization into detractors or at least make them ambivalent.

If the answer to all these types of issues becomes--upgrade to 2008, then I may just lose the inroads I've made with Microsoft BI in our organization because it's going to be more than a year before we have any chance of getting 2008 in here.
Posted by Steve_Walker on 12/5/2007 at 4:49 PM
Concurr
Posted by Simon Sabin on 11/6/2007 at 4:16 PM
Sorry but how on earth are can Delete be used to achieve the same results as Undo?
Posted by Microsoft on 11/6/2007 at 4:12 PM
Thank you for your feedback; however, by design, "Undo" is not enabled in BIDS. Please use "delete" to modify your needs.
Posted by Jamie Thomson on 11/6/2007 at 7:17 AM
I've commented in the past that this is severely lacking. I thought I had raised a Connect sumission for it although it was so long ago it may have been on the old MSDN Product Feedback site.

Yes, please give us CTRL-Z in the designer.
Sign in to post a workaround.