Tuesday, September 10, 2013

SSIS : SSIS toolbox is not visible in SQL Server Data Tools (SSDT)

Yesterday, I was asked by one of my reader that he is not able to see the toolbox in SSIS 2012.  I have provided the way of getting it and thought of sharing which may help you guys.
Previous to SQL Server Data Tools (SSDT), we were using Business Intelligence Development Studio (BIDS) to develop SSIS packages. In BIDS when we click on Toolbox icon which opens the SSIS Toolbox window whereas in SSDT which opens the user control toolbox as shown below:

So, how to get the SSIS toolbox in SSDT?  There are two ways to get the toolbox, one is by clicking on the icon as shown below or selecting the menu from View -> Other Windows -> SSIS Toolbox

Hope you got the SSIS toolbox in SSDT J