August 24, 2009 at 4:07 am
One of the problem i got , was on editing the Job i cannot see anything inside when opening it again on editing the job , i got the below mentioned Error.
Error:
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)
If anyone faced the same problem and got any resolution please let me know.
Anyhelp will be appriciated
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 24, 2009 at 4:19 am
Have you checked the msdb database ? there maybe some sort of corruption.
August 24, 2009 at 5:13 am
Sounds like you have a dll which is unregistered, have you done any patching or service packs recently, which have failed.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 24, 2009 at 5:31 am
this is a new server
but can u please tell me the steps to regster it ? and also how can i verify whther it is still exist there or not ?
thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 24, 2009 at 5:54 am
This could be a real shot in the dark.
"C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll"
Dont really have enough information, but give it a shot, there should be something in the sql server error log or the sql agent log, which should help you further.
in theory after making a change like this, the server should be rebooted, or at the very least the sql service should be restarted
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 24, 2009 at 6:13 am
thanks
i wil try
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 5:22 pm
I have had this problem with SQL 2008 R2 servers.
This is supposed to be fixed in CU3 for 10.5, but I have not tested it yet.
On some servers I was able to workaround by doing the following:
Run cmd.exe as administrator:
click Start, then type "cmd.exe" without quotes into the "Search programs and files" box.
Once it found cmd.exe, right-click it and chose "Run as Administrator".
Type:
cd C:\Program Files\Microsoft SQL Server\100\DTS\Binn
REGSVR32.EXE dts.dll
Restart SQL Server Agent
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply