getting error when trying to edit existing sql server job

  • I've created a SQL Server Agent Job. Now I'm trying to edit the existing job. However, when I go to Step 1 in the list and click the Edit button I get the following error:

    Creating an instance of the COM component with CLSID {...} from the IClassFactory failed due to the following error: c001f011 (Microsoft.SqlServer.ManagedDTS)

    I seem to remember that SS has given me this error on a previous project in the past when I tried to edit a step in an existing job. I seem to remember that I was able to fix this in the past but this was only 1 time 5 years ago so I can't seem to remember what the solution was.

    Can you advise how to fix this?

  • Have a look at this connect item

    http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

    It lists some patches and SPs that should fix the issue.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply