Visual Studio 2010 / SSIS 2012 [ Sql Server 2012 ] Toolbox ( “I can’t see my SSIS 2012 toolbox in VS 2010” )

8 בנובמבר 2012

For some reason , you can’t develop SSIS 2012 Packages on Visual Studio 2012 , the Business Intelligence Projects of the Sql Server 2012 resides on Visual Studio 2010

On the other hand I have problem updating SqlServer 2012 Stored Procedures on the Visual Studio 2010 … but that’s another story

Problem :

I can’t see my SSIS 2012 toolbox in Visual Studio 2010

lets’ show it visually – there is no SSIS toolbox , all you see is “GENERAL”

SSIS_Before

Solution :

Usually when the Visual Studio Toolbox doesn’t appear correctly .. I go out and do the following :

  1. Open a Visual Studio Command Prompt ( from the “Visual Studio Tool” sub-menu )
  2. And write or “devenv /resetsettings” or “devenv /ResetSkipPkgs”

( more in here http://msdn.microsoft.com/en-US/library/ms241276(v=vs.100).aspx )

The other option I’ve learned on my search for solution is that

For Visual Studio 2010 delete certain files that serve the same purpose

del "%LocalAppData%\Microsoft\VisualStudio\10.0\*.tbd"
… ok , after this didn’t work , finally found it !
( in this part , a picture is the best solution for “what & where” )
it seems that two buttons were added for this , just click each one of them !

SSIS_After

 

SSIS_Var

 


 
הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

2 תגובות

  1. Fontaine11 בנובמבר 2012 ב 22:02

    My brother recommended I might like this website.
    He was totally right. This post actually made my day. You can not imagine just how
    much time I had spent for this information! Thanks!

    הגב
  2. Moffitt3 באפריל 2013 ב 12:10

    There's certainly a lot to learn about this issue. I love all of the points you made.

    הגב