Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why is my SSIS toolbox empty in Visual Studio 2019 community?

I installed Visual Studio 2019 Community and then installed data tools. I can open an Integration Services project but when I look at the SSIS Tooolbox, it's empty.

How do I fix this?

screenshot

like image 504
JJ. Avatar asked Aug 24 '19 22:08

JJ.


People also ask

Why My Toolbox is empty in SSIS?

To get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox – hey presto! it reappears. Maybe the correct answer worked for some people, but this answer worked for me! Thank you!

How can I get SSIS Toolbox in Visual Studio 2019?

You can also open the toolbox by clicking the toolbox button that is located in the top-right corner of the package design surface, or by clicking VIEW -> Other Windows -> SSIS Toolbox. If you can't see the toolbox, go to VIEW -> Other Windows -> SSIS Toolbox.

How do I get my SSIS Toolbox back?

To open the SSIS Tool box window, In package design tab, next to Package Explorer you will see two icons, click on second icon to open the SSIS Toolbox window. Another way to open the SSIS Tool box window, click on View tab then navigate to Other Windows then select SSIS Toolbox.

Where are SSIS Variables in Visual Studio 2019?

By default, the Variables window is located below the Connection Managers area in the SSIS Designer, in SQL Server Data Tools (SSDT).


3 Answers

This is a problem after Visual Studio does an update for Optimization.

I have confirmed that the fix is:

Open menu item: - Tools - Options - Environment - On the General Tab - DISABLE/uncheck - "Optimize rendering for screens with different pixel densities"

This solved my problem.

..Derrick..

like image 114
dtate222 Avatar answered Oct 16 '22 16:10

dtate222


I am using visual studio 2017, To get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox please see this link. This resolved it for me.

Adding the content below again, in case the webpage is not available in future.

I have installed the Data-Tier Application Framework and SQL Server Data Tools for VS 2017 . I created a solution then returned to it a week later and the SSIS toolbox had disappeared.

I opened the toolbox window using View -> Toolbox but it was empty.

To get the SSIS toolbox back, right-click on the SSIS design surface in the project and select SSIS Toolbox – hey presto! it reappears.

like image 53
Mike Aono Avatar answered Oct 16 '22 15:10

Mike Aono


A Picture is worth of thousand words

enter image description here

like image 21
PAS Avatar answered Oct 16 '22 14:10

PAS