Unable to create a SQL Job in my local machine

Error while creating a SQL Job in local SQL Server DB Instance.

I got below error when I try to create a SQL job in SQL Server 2005 Instance.

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. 

When i check for a fix, i see lot of users asking to uninstall and install the SSIS, but that does not resolve this issue.

This happens on 2 reasons.

1. If we don't have latest service pack installed (SP3) in your machine.
2. If we try to run the job with SQL Agent service account and that does have privilege to execute a SSIS package.

you can check the below code project link, which helps to create a proxy account for you domain account, using that you can run the job. 

Hope this helps.


CodeProject

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.