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?
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!
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.
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.
By default, the Variables window is located below the Connection Managers area in the SSIS Designer, in SQL Server Data Tools (SSDT).
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..
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.
A Picture is worth of thousand words
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With