Subscribe to this blog
Briefcase
Print
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed to open my toolbox, of course I went to the menu bar selected View > Toolbox. To my surprise the toolbox was completely empty.
What the #$%#? What to do? Well it’s actually pretty simple. Located on the top right corner are two icons. The first opens the variables window and the second opens the SSIS TOOLBOX. Nice, I like it.
If your toolbox is empty, don’t worry it’s just one click away.
As always, if you have any questions or comments about this post please email me at pleblanc@sqllunch.com.
Talk to you soon,
Patrick LeBlanc
Posted by Johnson Reddy on 25 October 2011
Hello Patrick,
I agree with you and i think visually, it seems pretty custom. But i was wondering, how useful is the feature in reality? In the previous versions of SSIS (Until 2008 R2), they are available as individual tabs which doesn't seem to be any issue even for accessing the toolbars simultanously.
Any thoughts?
Posted by angelakru on 11 July 2012
Patrick, you are a genius! I'd tried everything, including resetting my entire VS settings and nothing - your solution worked first time!
An observation: my toolbox first disappeared when I showed the variables window and docked it to my left (as a tab alongside toolbox and properties). Clicking the butting brings up an addition tab for "SSIS Toolbox" - my original Toolbox is still empty (for my SSIS project) but I guess this is correct (something I've never conscious note of before but seems logical when I think about it), as it populates when I open a Windows Forms project of mine and open a form in design mode.
So all is well in the land of VS again - and your simple solution has saved me a lot of time. Thank you!
Posted by dkhandka on 22 May 2013
Thanks a lot Patrick !!