Creating an instance of the COM component with CLSID Failed
January 17, 2012 3 Comments
Creating an instance of the COM component with
CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory
failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
Problem: When trying to edit a job step in SSMS, the above error occurs.
Although not very practical, restarting SSMS eradicates the error but does not prevent it from reoccurring.
A better solution has been very well documented here: http://geekswithblogs.net/NutAndBolts/archive/2008/06/06/sql_server_2005_event_id_208.aspx
UPDATE:
Ive had a reply to this Blog entry from Sethu Srinavisan from the Microsoft SQL Server team which notes that this issue is resolved in SQL Server 2008 SP3, and SQL Server 2008 R2 SP1. Full Details Here
Thanks Sethu!