Learn how to get started with SQL Server Integration Services and how to build an SSIS project with this demo focused webinar.
Problem
The SSIS Toolbox is very important in SQL Server Integration Services to
allow you to add components to the SSIS package. If you close the SSIS Toolbox
sometimes making it display again doesn't work. In this tip we look at
what is happening and how to resolve this issue.
Solution
Previous to SQL Server Data Tools (SSDT), we used the Business Intelligence Development Studio (BIDS) to develop SSIS packages. In BIDS when we click on
the Toolbox icon it opens the SSIS Toolbox window, but now in SQL Server Data Tools it opens the user control toolbox. In this tip I will describe how to get
the SSIS Toolbox window back. To demonstrate the solution I will use SQL Server Integration Services 2012.
This tip assumes that you have previous real world work experience building a simple SSIS Package.
Step 1:
Let's start SQL Server Data Tools and create a new SSIS Package. By default
the SSIS Toolbox window is on the left side, you can refer to the below image.
Step 2:
Let's close the SSIS Toolbox window by clicking on the close (x) button. After closing the SSIS Toolbox window,
the environment looks like the below image.
Step 3:
Now we want to open the SSIS Toolbox window again. To do this you would
normally go to VIEW in
the menu bar and then click on Toolbox as shown below.
When you click on Toolbox from the menu, it opens a new Toolbox window, but it is not what we
need. You can refer to the below image.
Step 4:
The following are two methods to show the SSIS Toolbox.
Method#1
In package design window, next to "Package Explorer" you will find two small icons.
The second icon as shown below will open the SSIS Toolbox window. You can confirm this
with a mouse over on the icon.
Method#2
You can also make it visible from VIEW -> Other Windows -> SSIS Toolbox, you can refer to
the below image.
Step 5:
Once you followed either of the above methods, the SSIS Toolbox window will
be displayed again as shown below.
I just recently installed Visual Studio 2015 and have been unable to find the SSIS Toolbox anywhere in the program. I followed the instructions in your excellent article but neither method works for me because 1) the two buttons, including the SSIS Toolbox, that are supposed to be to the right of Package Explorer do not exist and 2) the menu View > Other Windows list does not list SSIS Toolbox as an option to choose. Did I miss something in the program installation that is preventing me from seeing the SSIS Toolbox? How do I get SSIS Toolbox installed/setup in Visual Studio 2015? Any help would be greatly appreciated!! Thanks!
Thank you! I was stopped cold in the middle of the SSIS tutorial until I found your post. By the way, method #2 does not work for me since SSIS Toolbox is not among 'Other Windows' (VS 2015 with SQL Data Tools)
Wednesday, December 30, 2015 - 8:29:33 PM - Rakesh K Pandey
Ghanesh Prasad leads a team in Microsoft Business Intelligence and has over 5 years of experience working with SQL Server.
