35

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

Cody Gray - on strike
  • 239,200
  • 50
  • 490
  • 574
JJ.
  • 9,580
  • 37
  • 116
  • 189

7 Answers7

58

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.

Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
Mike Aono
  • 859
  • 2
  • 11
  • 17
52

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..

dtate222
  • 544
  • 4
  • 3
  • 1
    This fixed it for me as well. And I do have the Extension installed @Hadi but I was hoping you were right. I turned it back On after they showed up with the flag Off, but they disappeared again. The flag must be Off for the tools to show up. – Nick DeVore Sep 16 '19 at 21:14
  • 2
    Here's the developer community ticket https://developercommunity.visualstudio.com/content/problem/663977/ssis-toolbox-in-visual-studio-19-empty.html – Nick DeVore Sep 16 '19 at 21:18
  • Same applies for Visual Studio Professional 2019 v. 16.3.1 using framework 4.8.03752. I installed the separate SSDT package and the above behavior was demonstrated, this fix solved my issue. – George Sep 27 '19 at 15:27
  • Excellent find! I just spent some time reinstalling a new machine and I hit this issue. Saves me from throwing my box out of a window – Christopher Klein Oct 24 '19 at 14:44
  • This is an extremely unfortunate state of affairs – goofballLogic May 15 '20 at 07:28
  • problems back in 16.11.1, above fix doesn't work, but in settings xaml designer has to be enabled. – joe blogs Aug 24 '21 at 19:54
  • I had to restart VS but it worked after restart. Thanks! – Wojciech Jakubas Dec 09 '21 at 10:06
21

A Picture is worth of thousand words

enter image description here

PAS
  • 1,791
  • 16
  • 20
0

I think you should download and install the Integration Services Projects extension:

Since in Visual Studio 2019, for Analysis Services, Integration Services or Reporting Services projects, you have to install the appropriate extension(s) from the marketplace.

You can refer to the following official documentation for additional information:

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • 1
    Additionally, the extension can be searched within VS itself, through Tools > Extensions and Updates and search for Integration services and Install the same. – Venkataraman R Aug 26 '19 at 08:30
0

I had a project from 2017 and the toolbar would not open when I opened the project. I had to create a new empty project. Then go back and open the 2017 project. Then the toolbar appeared.

Joseph
  • 1
0

For me, enabling SSIS toolbox did the trick initially it did not show up in VS 2019 community

Steps : https://stackoverflow.com/a/48102622/2256502

Purnajith
  • 1
  • 1
-1

My two cents worth, I had the same issue-

In the toolbox window, right-click and select SHOW ALL.
Then right-click again, and turn off the SHOW ALL. Voilah...!

Neil de Later
  • 1