webyacusa
webyacusa

Reputation: 524

Why is the toolbox empty on VS 2010 shell used by SQL Server data tools?

I installed SQL Server 2012 and I imported my old SSIS projects into it. Everything is fine but when I tried to edit my package, surprisingly the toolbox is empty on the SQL Server Data Tools, and I have no idea how to bring those items back. Can anybody help?

screenshot

Upvotes: 15

Views: 13873

Answers (3)

Ardalan Shahgholi
Ardalan Shahgholi

Reputation: 12555

I had the same problem and there are two way to fix this problem very fast.

The first ones : open one of our package in top right of your package there are two buttons one of them is "variables" and second ones is "SSIS Toolbox". Press the second ones : "SSIS Toolbox".

enter image description here

The second way as user user756519 has said in above is selecting SSIS menu in VS and select SSIS ToolBox.

enter image description here

Upvotes: 2

user1910428
user1910428

Reputation: 189

I had a similar problem with 2012 (SQL Server data tools). See James post here: http://www.jamesserra.com/archive/2013/01/ssis-2012-empty-toolbox/

apparently there is a button (that doesn't appear in the menus)

I actually got so frustrated that I reinstalled SSDT; which fixed the problem for about a week, then I broke it again. Google search returned this post on top, so I'm re-posting. Thanks

Upvotes: 3

user756519
user756519

Reputation:

Click SSIS menu --> SSIS Toolbox to view the SSIS specific toolbox on SQL Server Data Tools (previously known as Business Intelligence Development Studio).

The toolbox shown in the screenshot of the question is related to Visual Studio toolbox, which can be found under View menu --> Toolbox . This is different from the SSIS Toolbox.

SSIS Toolbox

Upvotes: 39

Related Questions