VS or BITS Toolbox items missing

When i open my Business Intelligence Studio to update my SSIS package, i noticed that all my toolbox items were missing. When i try to add that using choose components, I am able to add all the items which are missing. But the grouping of items as sources, destination and so on are not happening with that manual addition of items.

I Google and many answers mentioned to import tool box settings, but that does not work. Also some people asked to re-install or repair, that does not works. 

One of the solution was to delete the files in the cache folder, that is the only solution which really helped.

Delete the files which starts with toolbox or with extension tdb from the location:

For Windows 7 - C:\Users\bmanohar\AppData\Local\Microsoft\VisualStudio\8.0

Others OS - C:\Documents and Settings \bmanohar\Local settings Application Data\Microsoft\VisualStudio\8.0

I am trying to fix the issue for VS2005, so cleaning the files from location 8.0. for 2008 check 9.0 and 2010 check 10.0

deleting the files does not harm your studio any way, because it as cache file. It will create a fresh copy when you open the studio next time in the same location.

No comments:

Post a Comment