SSIS - Missing SSIS toolbox in Visual Studio

Problem:

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?

Solution:

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.

Comments

Popular posts from this blog

SSIS - Script Task error: Exception has been thrown by the target of an invocation.

Don’t install Hadoop on Windows!

SSIS - script component DateTime Formats Implicit Conversion