//
home

Latest Post

SSIS 2016: Empty toolbox?

I recently upgraded several SSIS packages from VS2010 (SSIS 2008R2) to VS2015 (SSIS 2016). After the initial upgrade\conversion when I opened the package(s) I noticed that the Toolbox pane was empty, displaying a “There are no usable controls in this group.  Drag an item onto this text to add it to the toolbox.”.  What???  Where are all my SSIS tasks?  As it Turns out, SSDT now has two toolboxes: one called “Toolbox” and a new one called “SSIS Toolbox“.  The default toolbox is apparently the “Toolbox” not the “SSIS Toolbox”. So I go to the “View” menu item, but “SSIS Toolbox” is not listed!  Instead, there are two new buttons on the far-right of the screenshot below, with the second the button to click to open the “SSIS Toolbox”:

clip_image002

Not very intuitive!  Hopefully this will help you avoid the confusion and wasted time I had encountered looking for my SSIS tasks.

UPDATE: You will see a “SSIS Toolbox” under View -> Other Windows if the a dtsx window has the focus (along with menu items “Variables”, “Log Events”, and “Getting Started”), but not if any other window has the focus.  What makes it more confusing is that the SSIS Toolbox at menu item should always appear no matter what window currently has the focus but doesn’t.

Bon Appetite

Advertisements