Missing SSIS toolbox in Visual Studio 2017

sql-server visual-studio ssis etl sql-server-data-tools
Shriram Rao picture Shriram Rao · Jan 4, 2018 · Viewed 30.7k times · Source

I am running SQL Server 2014 on my machine. I have installed SSDT for Visual Studio 2017, which I also have. Now I am not able to find the SSIS Toolbox in my Visual Studio. Do I need to re-install the SSDT all over again? Please let me know. Thanks in advance.

Answer

Hadi picture Hadi · Jan 4, 2018

If SSDT is installed correctly

You can show SSIS toolbox in 3 ways:

(1) Visual Studio Menu strip

Based on this Microsoft article:

If you can't see the toolbox, go to VIEW -> Other Windows -> SSIS Toolbox.

enter image description here

(2) From Context Menu strip

Or just Right click inside the Control Flow of any parent/child package and select 'SSIS toolbox', then the SSIS toolbox will be displayed just after that click. Read more

enter image description here

(3) Near SSIS tab pages

You can find a small button near the SSIS tab pages as shown in the following image:

enter image description here

If none of the above method worked then you should install SSDT correctly.

Related questions

SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that …

Read More
Disabling SSIS Package Validation when Loading a Package in the VS Designer

I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the packages, the designer always validates …

Read More
SSIS package shows blank screen in design mode

I created a SSIS package using SQL Server data tools 2015 a week back. And today i opened the package and it just shows the blank screen. I read about this issue here and it seems that was the defect in …

Read More