Monday, June 8, 2009

SQL Server Schedule Job : Unable to cast object of type

Hi Folks...

One of my pal, when he was trying to create SQL Server Job to call a SSIS he got the following error;

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

When we googled for the same it was mentioned in lot of forums that the it worked fine once we install SQL Server 2005 service pack 2 (SP 2)

Reference: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/e7c0e73e-8d4b-4624-a19e-352a69995f9e

Download: Microsoft SQL Server 2005 Service Pack 2

Regards
Fauzi ~ 4Z

No comments: