I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2
installed). Recently, I have run sql server hotfixes deliveres over our
organizational sus server. Although, it was run at least 6 times update could
not be finished. Some errors were reported.
Now I can not run DTS, or create new job vis ms sql sms. I will copy error
message I have got, so, anybody who could know what is the reason for this
and how to resolve, please, help me.

Error is following (part of technical details, I could send log file also):

"The SSIS Runtime object could not be created. Verify that DTS.dll is
available and registered. The wizard cannot continue and it will terminate.
(SQL Server Import and Export Wizard)

===================================

Unable to cast COM object of type
'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNe utralClass' to interface
type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConta iner90'. This
operation failed because the QueryInterface call on the COM component for the
interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the
following error: Interface not registered (Exception from HRESULT:
0x80040155). (Microsoft.SqlServer.DTSRuntimeWrap) ... "

regards,
Amir

Hello Amir,


Sounds nasty

Have you tried

#
Open the command prompt
#
Navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
#
Run C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll


If you decide to go through this route then please pet us know how you got
on.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

I agree it is nasty and it makes me nervous.
Just tried to register acc. to your sugestion and I have got following message

DllRegisterServer in dts.dll failed.
Return code was: 0x80070005

Strange. So this does not help.
Thank you for answer.

"Allan Mitchell" wrote:

Hello Amir,

Thanks for getting back. That error relates to E_ACCESSDENIED

There is a brief discussion here

http://www.pcreview.co.uk/forums/thread-2471843.php

What it may though be worth doing is getting the SP to install correctly
and see if that fixes things up.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

Hi Allan,

this was very helpful. Although I believed I was in local admins group I
still had to play with registry acc. to thread from pcpreview where you
"directed" me. After registering dts.dll, now dts work as well as creating
new maintenance plan.

Thank you so much.
Amir

"Allan Mitchell" wrote:

Dear Allan Mitchell,

The above suggested solution worked, now i am able to open maintainance plan in SQL server 2005.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll


Thanks a lot

From http://www.developmentnow.com/g/103_...erver-2005.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Dear Allan Mitchell,

The above suggested solution worked, now i am able to open maintainance plan in SQL server 2005.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll


Thanks a lot

From http://www.developmentnow.com/g/103_...erver-2005.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Dear Allan Mitchell,

The above suggested solution worked, now i am able to open maintainance plan in SQL server 2005.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll


Thanks a lot

From http://www.developmentnow.com/g/103_...erver-2005.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Dear Allan Mitchell,

The above suggested solution worked, now i am able to open maintainance plan in SQL server 2005.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll


Thanks a lot

From http://www.developmentnow.com/g/103_...erver-2005.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Dear Allan Mitchell,

The above suggested solution worked, now i am able to open maintainance plan in SQL server 2005.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll


Thanks a lot

From http://www.developmentnow.com/g/103_...erver-2005.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com