Job step edit error

  • This is the following result I found when I try to edit the job step.

    Job -> right click -> Properties -> job step -> edit

    What is the root cause of this error?

    "Creating an instance of the OCM component with CLSID {E80*************}" from the IClassFactory failed due to following error:c001f011(Microsoft.sqlserver.ManagedDTS)"

  • Hi,

    Which version of SQL SErver are you on (SELECT @@version)? There seem to be a bug in earlier builds (http://support.microsoft.com/kb/918222/en-us contains a fix).

    Does it always happen, even if you restart SSMS?

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • This is Yukon

  • Please can you try out the following:

    RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll

    You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn

  • vmenon (11/4/2008)


    Please can you try out the following:

    RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll

    You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn

    Hi,

    I had the same problem after I installed SP3 on my SQL 2005 standard edition, Win 2003 server. Your solution works like a charm.

    Thanks for the solution !!

    \\K

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • I was having the same problem, and your suggestion solved it! Thanks!!!

  • phbianchi (7/1/2009)


    I was having the same problem, and your suggestion solved it! Thanks!!!

    Glad it helped you !

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • I was having the same issue after installing SSMS SQL2008R2.

    The regsvr fix worked like a charm. 😎

    ( I first changed my current directory in the command prompt to "C:\Program Files\Microsoft SQL Server\100\DTS\Binn" )

    Thanks.

    edited:

    This has only been a temporary solution. I don't know why, but it started giving these errors again after a couple of days. (btw: I have SQL2K, SQL2K5 and sql2008R2 full installs dev-edtn on my laptop)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Help !!! I'm getting the same type of issue where I can't edit Job Steps.

    I just installed

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

    Apr 2 2010 15:48:46

    Copyright (c) Microsoft Corporation

    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

    On Windows Server 2008 R2 Standard 64-bit OS

    I tried the fix everyone has suggested : Pointed to folder

    C:\Program Files\Microsoft SQL Server\100\DTS\Binn and ran REGSVR32.EXE dts.dll then bounced the

    service.

    But after I create a couple of test jobs and try to edit them a couple of times, the error returns.

  • I am having the same issue after installing SSMS SQL2008R2. Has anybody found a long term fix for this by chance?

  • There is a fix - Cumulative Update package 3 for SQL Server 2008 R2 -

    http://support.microsoft.com/kb/2261464

    I applied this and it resolved the issue... If you wade through the KB you'll see the problem listed.

  • Great, Thanks for the reply

  • Cool, Thanks, I was having the same problem while trying to create any maintenance plans on R2.

    the update called "sqlncli.msi"

    41822

  • Damon Falconi-345992 (9/1/2010)


    There is a fix - Cumulative Update package 3 for SQL Server 2008 R2 -

    http://support.microsoft.com/kb/2261464

    I applied this and it resolved the issue... If you wade through the KB you'll see the problem listed.

    Indeed, after CU3 - for the moment - this jobstep editor issus vanished :w00t:

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • after you register dts.dll restart your ssms.

Viewing 15 posts - 1 through 15 (of 19 total)

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