Missing SSIS toolbox in Visual Studio 2017

问题:

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.

回答1:

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.

(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

(3) Near SSIS tab pages

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

---

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