Category: General

Missing Toolbox Items in Business Intelligence Development Studio

By Sean, January 10, 2012 19:28

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)

In the beginning…

By Sean, February 20, 2010 12:03

While this is the first actual post on my blog, it has no reference to SQL or any other technology for that matter.

I am actually working on the first entry, but it is not anywhere near being complete and I didn’t want to just leave the standard “Sorry, you’re looking for something that isn’t here” on the front page of KeepITSQL.com. So here is a short introduction to really say thank you to the online community which I have used a great deal in the last few years. This community is ultimately the reason for me creating this little bit of web in the first place.

There are so many really good quality online sources out there and, among them, a few have inspired me to take the plunge into blogging. I would like to mention just two of the few (I hope they don’t mind):

  1. Brad McGehee has a brilliant knack of being able to explain the sometimes very complex concepts of database administration and putting them into context. He is also brilliant at getting that information out into the public. Check out his website.
  2. Gail Shaw tipped the scales for me when I read her post “Getting here from there”. Gail can really get down to the nitty gritty when it comes to performance issues and in a way that’s easy to understand. (I was really stoked to find a fellow South African right up there on the “International SQL Scene”)

I don’t even hope to be able to compete with Gail or Brad (that would be presumptuous indeed), but I am where I am and would like to start the journey of getting to where they are.

With a little help from my friends, I don’t see why that shouldn’t be possible.

Happy reading

Sean

Panorama Theme by Themocracy