Visual Studio standard Toolbox VS the "SSIS Toolbox" - by Todd C

Status : 

 


2
0
Sign in
to vote
ID 778510 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 2/4/2013 7:05:45 PM
Access Restriction Public

Description

Using SQL Server Data Tools for VS 2010 and developing an SSIS Package, somehow the Toolbox got closed. NOt sure how. Upon re-oppoening, it was EMPTY. It took me DAYS of anguish and deleting the Toolbox.TBD files and re-installing and repairing and whatever else to try to get those Control Flow and Data Flow elements BACK on the Toolbox.

I finally came across a post that mentiioned the difference between the standard VS Toolbox and the SSIS Toolbox. When did that happen?

Any why, when I open an SSIS package, does it not open the SSIS Toolbox? 

VERY Frustrated.
Sign in to post a comment.
Posted by Todd C on 8/30/2013 at 7:25 AM
Are you guys absolutely CLUELESS?

READ THE POST: Key phrases to look for: "VS 2010" and "SSIS Package", right there in the first sentence!. Heck, read the TITLE: "SSIS Toolbox"

Now read your latest comment: "unable to reproduce the behavior locally using SSMS 2012" DUH!

Steps to re-produce;
1)Start an SSIS project in Visual Studio 2010.
2)Close the SSIS Toolbox by clicking the [X]
3)Save the project and solution, and close Visual Studio.
4)Re-open VS and open the Project.

Note that the SSIS Toolbox does NOT get opened with the SSIS Project. Why do you need a separate Toolbox for SSIS Projects? Why not put the tools in the standard Toolbox like you had it in 2005 and 2008? And if you are going to have separate toolboxes for different project types, why not have an SSRS Toolbox?
Posted by Microsoft on 7/5/2013 at 9:26 AM
Hello Todd. Thank you for reporting this problem to us. However, we have been unable to reproduce the behavior locally using SSMS 2012 RTM. We recommend you try this scenario again with a clean installation of SSMS 2012. We will be closing the issue as a “no repro.” If a fresh installation of SSMS 2012 still faces this issue, please get back in touch with us and we will assist you.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Todd C on 5/23/2013 at 9:56 AM
Really? You want to know the version? Read the post: "Using SQL Server Data Tools for VS 2010 . . ."

And since neither VS 2005 or VS 2008 has any concept of a "SSIS Toolbox", that kind of sums it up.
Posted by Microsoft on 5/23/2013 at 9:50 AM
Hello Todd. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. You can save us a lot of time by letting us know with which versions of Visual Studio and SSIS/SQL are you working when you're making this old-vs-new behavior distinction. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)