Missing Toolbox Items in Business Intelligence Development Studio
I haven’t blogged for ages as I have found it difficult to set time aside to do so, but I wanted to share this little bit of information all the same.
I wanted to create a SSIS package and found that my toolbox was no longer displaying the controls that I was expecting. The toolbox panel displayed a single group with the title “#13119″.
The problem was that the toolbox cache for Intelligence Development Studio (in my case Visual Studio) was shot – how this happened I don’t know.
The solution was to close VS, delete the toolbox*.tbd items under “C:\Users\USERNAME\AppData\Local\Microsoft\VisualStudio\9.0″ and start VS again. The toolbox controls appeared as expected.
NOTE: The path is valid for Windows7 (and presumably Vista). For XP it would be something like this: “C:\Documents and Settings\USERNAME\Local Settings\Application Data\Microsoft\VisualStudio\9.0″.
I found the solution on a German website, so this is really just an English translation, which I hope proves to be useful. (Thank you Rainer Hilmer)