Home Dashboard Directory Help

SSIS 2012 Control Flow moving objects is unusable by Mike Honey - Manga Solutions


 as Fixed Help for as Fixed

Sign in
to vote
Type: Bug
ID: 776664
Opened: 1/15/2013 10:56:33 PM
Access Restriction: Public
User(s) can reproduce this bug


There are multiple usability problems moving objects on the Control Flow interface in SSIS 2012 (in Visual Studio 2010): Moved objects have a tendancy to fly off a huge distance away from the source for no apparent reason. You cannot move objects beyond the top edge of the existing surface, beyond a tiny margin. The functionality in the 2008 version to auto-connect and position new objects has been removed.
Sign in to post a comment.
Posted by DogTog on 6/4/2014 at 2:47 PM
Embarrassing that this has lasted this long without it getting addressed. Regardless how wonderful this feature is... usability and UI design should have been granted extra attention. There seem to be a hotfix for this now... don't forget to click on the "Workaround" tab.
Posted by Mike Honey - Manga Solutions on 11/13/2013 at 7:33 PM
Hi Microsoft,

Thanks for that update. My summary of the comments this month by Peter and Paolo are that:
1) The Control Flow interface is much worse using VS2012
2) None of the currently available hotfixes etc resolve these issues.

So I'm unclear exactly what you mean by "future fixes"?

Also, I think the Status of this Bug should be reviewed - it seems clear from your own post that the issue is not currently "Fixed".

Posted by Microsoft on 11/11/2013 at 9:59 AM
For future fixes to the behavior of the Control Flow, please see here:http://connect.microsoft.com/SQLServer/feedback/details/805774/ssis-designer-for-visual-studio-2012-is-close-to-unusable
Posted by K Dahl on 11/11/2013 at 9:43 AM
The Microsoft person posting that this issue was fixed in SQL 2012 SP1 CU3 is just plain wrong.
Posted by StevoSmocilac on 10/29/2013 at 6:22 AM
There is a hotfix which seems to fix this issue in Visual Studio 2010, http://support.microsoft.com/kb/2883424/EN-US, however there still doesn't seem to be a fix for Visual Studio 2012.
Posted by McMike79 on 10/28/2013 at 8:52 AM
I also ran CU3 last week and there has been no change to this UI issue.

SSIS Designer Version 11.0.3369.0
SSDT 11.1.31009.1
Posted by Erik Beijer on 10/25/2013 at 5:47 AM
I have installed KB2812412 (Cumulative update package 3 for SQL Server 2012 Service Pack 1) effectively updating my SSIS Designer version to 11.0.3369.0 and nothing has changed! The annoying flickering of controls in Control Flow and in Data Flow is still present. Any plans on really fixing the bug now?
Posted by Recurs1on on 10/21/2013 at 11:45 AM
I'm also still having the issue after applying the hotfix.
Posted by StevoSmocilac on 10/18/2013 at 12:28 PM
Just loaded CU6 for 2012 SP1 but I am still having this issue?
Posted by Microsoft on 10/18/2013 at 9:24 AM
We always recommend updating to the most recent Cumulative Update for troubleshooting. In this case, the issue has been resolved since CU3 for SP1 and CU6 for RTM.
Posted by Peter Donaghy on 10/17/2013 at 5:53 PM
Come on Microsoft. You will be losing significant market share in the ETL space if this buggy interface is not fixed immediately. I charge a high hourly rate to my clients but this interface is effecting my productivity significantly. I cannot understand why 1) this issue has a status of "Closed" and 2) why the requisite resources aren't provided to fix this asap. Get going quick or I'll be reflecting on dusting of my skills with competing ETL packages.
Posted by McMike79 on 10/11/2013 at 6:49 AM
Any updates on this? I see 3 topics on this same issue where MS has stated a fix is in the works, but I just applied the RC4 update that was released last week and I'm still having these issues that makes development quite difficult and borderline unusable in some scenarios (such as resizing containers).
Posted by Erik Beijer on 10/11/2013 at 2:17 AM
It's a shame this GUI ever got out. I mean I hear Microsoft speakers at DevDays (NL) boasting about using somewhere around 75% percent of development time for testing, but no one ever bothered to test the designer then? Try making things better instead of worse: in my experience the VS 2008 designer had no, or at least less, flaws.

When will the fix be released?
Posted by Christopher Haws on 10/9/2013 at 2:01 PM
Please release a hotfix for this! The only way I am able to move controls is by holding down Ctrl and using the arrow keys... This is completely unusable...
Posted by dsa42x on 10/7/2013 at 9:37 AM
I really want to complain about this, and I hope many others follow suit. This interface is COMPLETELY UNUSABLE and should NEVER have made it out of QA. But, worse than that, it was reported in JANUARY. It took SEVEN MONTHS for it to be fixed, but in 8/22/13 Walter Jokiel reported it fixed. 71 people have voted on this as an issue, but yet it is OCTOBER, and we still do not have any hot fix. I doubt that it has to be a hot fix to SQL Server, but rather to Visual Studio or at least SSDT-BI.

Now, worst of all on 9/10/13, Peter Donaghy asked for Mr. Jokiel to post an ETA for the hot fix, and Mr. Jokiel has not even done that. COME ON MICROSOFT, this is a serious problem for us. Please deliver a hot fix and GIVE US AN ETA
Posted by garyhumph on 9/22/2013 at 7:13 PM
I naively chose to upgrade to VS 2012 (full purchase "Ultimate") from using VS 2005 - under which I had successfully created several major ETL packages during the past 4 years, assuming that VS 2012 would be an improvement. I have struggled through another major ETL project recently battling this ridiculous SSIS UI. I see that this issue is closed as fixed. When will the fix be released? I would not recommend this product in its current state to any of my developer colleagues who are involved in SSIS based projects.
Posted by Recurs1on on 9/17/2013 at 1:52 PM
I agree with Peter that we need a hotfix for this asap. Please at least let us know when the release will be available, even it will not be released right away, so we know how much longer we will have to deal with it. Thanks.
Posted by Peter Donaghy on 9/10/2013 at 11:33 PM
Hello Mr Jokiel.
Some of us are really struggling with this buggy interface and need a better idea of when this 'fix' will be available. Can you please release this as a Hotfix so we can get this resolved asap?
Posted by Matt_Unks on 8/26/2013 at 8:58 AM
I would also like to add that when i try to make the icons the 'same size' it rarely if every makes them the same size. They are "closer" is size but still not the same. I am unable to readjust them manually or by using the FORMAT options from the menu.

And when I use Horizontal Spacing Make Equal they suddenly shift and look like the following:


As opposed to say this:


I tried vertical spacing and it did nothing. I am hoping the fix for the Jitterness will also fix this. Very frustrating to have different sized objects that no matter what I try, I am unable to get them nicely aligned and the same size.

Posted by Microsoft on 8/22/2013 at 2:25 PM
Hello All. Thanks for bringing this to our attention and your feedback. This has been fixed. The change will be included in a future release or servicing release for SQL Server.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Berthold Neumann on 8/20/2013 at 5:45 AM
The whole User-Interface in the control is a horror.
There is no need for the auto-formart function.

In 2008 it was very simpel and realy perfect.
Posted by loraxxarolloraxxarol on 8/15/2013 at 10:04 AM
Exactly as described in these posts. Could have begun occurring after an update of some kind, because it wasn't always like this.
Posted by icastel on 8/9/2013 at 4:22 PM
Not meaning to beat this horse to death, but really? I'm spending more time finding and herding my controls as they fly off to unknown corners of the design surface than actually doing any productive work. And, what's with the jitters afflicting the controls when I try to position them? Are they too afraid of the mouse and so fly off to the upper left corner? FIX FIX!!!
Posted by Stephanie Jacobs on 7/31/2013 at 12:17 PM
This is a big problem. We've already gone to Visual Studio 2012 and can't go back to 2008. I don't like to use the auto layout because it just messes things up. Clicking and dragging things around is the only feasible way to position things.
Please fix this bug as soon as possible.
Posted by dline292 on 7/31/2013 at 9:09 AM
My shop just upgraded to 2012 and all the developers are experiencing this problem. Using the mouse to drag any task around in the designer results in a jittery outline of the task that is extremely difficult to drop in the desired location. To make it even worse, the jittery outline often disappears and results in the task being dropped in the top left hand corner of the designer.

There is no way that QA tried to design a package without noticing this major bug. It makes the product very difficult to use and wastes a lot of time.

We love the new features of 2012, but this bug is horrible. Please fix.
Posted by cameron_eldridge on 7/30/2013 at 5:20 PM
I'm seeing this across multiple machines here. It's truly horrid to use. It's like they didn't even test this, I'm not sure how anyone using it thought it would be acceptable to release it in it's current state.
Posted by maryxxxx on 6/23/2013 at 7:00 PM
Agree -- this is horrid
Posted by DiykoR on 3/22/2013 at 5:24 AM
I have also found this problem. It is particularly problematic when moving groups and FOR..LOOP containers. The containers fly off down the page and you can't get them back to the top.
Sign in to post a workaround.
Posted by icastel on 3/11/2014 at 3:27 PM
I can confirm what StevoSmocilac mentions below. I searched my system for that file, "Microsoft.sqlserver.integrationservices.graph.dll", and found that the version in my Visual Studio 2012 was older than the one in the Visual Studio 2010 folder. I copied the file

From (my VS 2010 install folder): C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies
To (my VS 2012 install folder): C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies

That seems to have fixed the problem. First, of course, I had to install the hotfix http://support.microsoft.com/kb/2883424/EN-US.
Posted by StevoSmocilac on 10/31/2013 at 4:00 PM
After you apply the hotfix, http://support.microsoft.com/kb/2883424/EN-US to get this resolved for Visual Studio 2012 you need to manually copy the hotfix file, (Microsoft.sqlserver.integrationservices.graph.dll, under <vs>\Common7\IDE\PrivateAssemblies) from the VS 2010 to the VS 2012 directory.
Posted by icastel on 8/9/2013 at 5:12 PM
One minor workaround, that sort of resolves some of the problems, is to set the zoom level on the design surface to "Fit view to window" by clicking the button at the bottom of the zoom control (bottom right). That allowed me to get my controls back to where I could re-arrange them, but still has issues with the control outline jitter, dropping in unexpected places, inability to correctly resize my sequence containers, etc. Pfft.