//
you're reading...
BI, SQL Server BI, SSIS

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

About ldgaller

Accomplished Data Warehouse Architect, DBA and Software Architect with over 15 years of professional experience and demonstrated success designing and implementing solutions that improve business functionality and productivity. Highly diverse technical background with proven ability to design, develop and implement technology on an enterprise level. I approach all projects with passion, diligence, integrity, and exceptional aptitude.

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: