I work with BizTalk (BTS) and SSIS frequently. In one of my environments, whenever I've programmed in BTS, then jump back to SSIS, the SSIS toolbox is missing in action.

Here's what I do to solve the problem in that environment:

  • Save the application and close Visual Studio.
  • Go your AppData\Local\Microsoft\VisualStudio\[whatever version]
  • Rename the *.tdb files there to something else like *.tdb.x
  • Open Visual Studio  (Note: You will see the progress status bar re-initializing all available toolboxes.)
  • Open the application.
  • On the canvas, navigate to a space without an annotation or a component.
  • Right Click and select SSIS Toolbox.

Update: I recently upgraded from vs2010 to vs2012 in another environment without a biztalk installation-- in this case, when the toolbox wasn't visible, I just went to the canvas, did a right click, selected on SSIS Toolbox and that solved the issue. Try this action first. This may be all you need to do to resolve this issue in your environment.
posted on Thursday, July 11, 2013 4:19 PM
Filed Under [ Practical Answers BizTalk SSIS ]


# re: SSIS: My Toolbox is Missing!
posted by debra
on 1/14/2014 12:35 PM
i guess that was good advise if i only knew what she was talking about!
# re: SSIS: Myy Toolbox is Missing!
posted by askpaula
on 1/15/2014 4:48 PM
@Debra, the best advice ever!! :) BizTalk and SSIS (Sql Server Integration Services) are Microsoft products used for migrating/transforming source data to target destinations. Both of these tools have a visual component for creating data/control flows. Every once in awhile the canvas or work area looses track of the toolbox associated with it.
# re: SSIS: My Toolbox is Missing!
posted by Adriano Nebbia
on 3/19/2015 6:32 AM
Right click inside the Control Flow of any parent/child package and select 'SSIS toolbox'
The tool box will be displayed just after that click
# re: SSIS: My Toolbox is Missing!
posted by Corey
on 4/22/2016 11:34 AM
Just wanted to thank you for this, I always use the net (with varied results) when I am stuck. Your simple solution handled my issue, thanks!
# re: SSIS: My Toolbox is Missing!
posted by Alexey Honorio
on 12/8/2016 7:32 AM
Just to thank you! It solved my problem.

Best regards from Brazil o/
# re: SSIS: My Toolbox is Missing!
posted by Jorge
on 4/5/2017 4:10 PM
Thanks , it worked ...
# re: SSIS: My Toolbox is Missing!
posted by Dimitri
on 10/30/2017 8:57 AM

The right-click on the canvas, and select SSIS Toolbox...

Thanks again

Post A Comment