When I opened an existing SSIS project in the new SQL Server 2012 RC0, I came to an interesting discovery: an empty Toolbox pane! Even with an SSIS package open in the designer. Hmm, that’s funny! So where are my SSIS components?
Take a good look at the following screenshot:
That’s right, they are not in the Toolbox anymore but in the SSIS Toolbox instead. This new toolbox is a bit different from the old one. Besides the grouping of components that has changed, the most important change is that it will automatically detect any custom components. You no longer need to right-click, select Choose Items, go fetch a coffee, wait until it cools down a bit, drink it and finally … select your custom component. No, you’ll have to find another reason to get that coffee shot. Actually, that’s not entirely true: you still need to right-click and then click Refresh Toolbox and then the custom components will be shown.
Another difference is that it’s split in two parts. The bottom half of the pane now contains a description of the selected item, including a link that should lead to samples and a link to the Books Online.
Out of curiosity I tried the Find Samples link a couple of times, but for now it doesn’t seem to deliver much content:
Okay, so one thing remains: how do you open the new SSIS Toolbox pane? According to the Books Online it should be opened automatically when you open an existing project. Well, apparently not all the time!
The first place I’d look is in the View menu. But alas, SSIS Toolbox is not one of the menu items. Not even in the Other Windows submenu. Why oh why?!
Long story short: do you see those two buttons in the below screenshot? They’re new!
The first button leads to the Variables pane, the second button will open the SSIS Toolbox. Good to know isn’t it?!
Further investigation led me to the following: according to the Books Online, the SSIS Toolbox item should actually be located in the View > Other Windows menu. As that is not the case and I think it’s only logical to have that pane added to the View menu as well, I’ve filed a bug on Microsoft Connect. Go ahead and vote!