Job step edit error

Question

Job step edit error

ashish.johri

Mr or Mrs. 500

Points: 560
More actions
November 2, 2008 at 11:57 am

#128229

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)"

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

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

Elisabeth Rédei Hall of Fame Points: 3873 More actions · Answer 1

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

ashish.johri Mr or Mrs. 500 Points: 560 More actions · Answer 2

ashish.johri

Mr or Mrs. 500

Points: 560

November 2, 2008 at 2:49 pm

#892853

This is Yukon

vmenon SSC Veteran Points: 274 More actions · Answer 3

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

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 4

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 🙂

phbianchi SSC Journeyman Points: 97 More actions · Answer 5

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

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 6

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 🙂

Johan Bijnens SSC Guru Points: 135364 More actions · Answer 7

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

Damon Falconi-345992 Old Hand Points: 369 More actions · Answer 8

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.

Keith Edwards Default port Points: 1446 More actions · Answer 9

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

Damon Falconi-345992 Old Hand Points: 369 More actions · Answer 10

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.

Keith Edwards Default port Points: 1446 More actions · Answer 11

Keith Edwards

Default port

Points: 1446

September 1, 2010 at 9:30 am

#1215089

Great, Thanks for the reply

JasonYousef SSCommitted Points: 1769 More actions · Answer 12

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

the update called "sqlncli.msi"

41822

Johan Bijnens SSC Guru Points: 135364 More actions · Answer 13

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.