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

This is a very funny error message Smile. I saw, you guys are looking for this, but it was published in Hungarian. Now I translate the article to English.

You got this error message when you are trying to schedule an SSIS package. This occurs because of the different service packs for the SQL Server installation. You should run the service pack 2 setup (download from here: http://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en) and apply the updates to your SSIS instance. After the installation, try to schedule the package again.... and you should not have the error message.

This error should occur in this scenario: you installed just the database engine first and applied the SP2, then you figured out, you need SSIS as well. You perform an SSIS installation next to your SP2 database engine, but SSIS is installed without SP2. This is the reason why you need to run again the service pack update.

Hope, it helps to you. Leave me a comment if you feel.

[updated: 2011.08.29]

Comments (1) -

very good !thanks

Add comment