can not run DTS on sql server 2005

Question

can not run DTS on sql server 2005

Amir Steta

SSC-Addicted

Points: 413
More actions
June 28, 2007 at 7:07 am

#174208

I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2 installed). Recently, I have run sql server hotfixes delivered 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 via 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.PackageNeutralClass' to interface
type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. 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 to all,
Amir

Viewing 6 posts - 1 through 5 (of 5 total)

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

bledu SSChampion Points: 12335 More actions · Answer 1

are these sql 2000 DTS packages on SQL 2005. Try to reinstall the Microsoft SQL Server 2000 DTS Designer Components that are part of the Feature pack

http://msdn2.microsoft.com/en-us/sql/aa336314.aspx

Everything you can imagine is real.

Amir Steta SSC-Addicted Points: 413 More actions · Answer 2

I have got sql server 2005 standard edition, as I wrote. This does not seem to help.

Amir Steta SSC-Addicted Points: 413 More actions · Answer 3

the problem resolved on microsoft newsgroup. it was about registering dts.dll.

I will copy two messages from Allan - guy who helped just in case that somebody else have similar problem.

here is first message:

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

After this I could not register dll. I am in local admin group but I had to play with registry acc. to Allan's second message. This is it:

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

bledu SSChampion Points: 12335 More actions · Answer 4

i did think of registering the dll but the reason why i had said try using the dts pack was so that if there was anything else that was broken then it should have been solved as well, reinstalling apps usually solves broken dll registrations. and by the way i don't think the dts pack is provided as part of the service pack, you have to download and install.

thanks for getting back with the solution

Everything you can imagine is real.

Amir Steta SSC-Addicted Points: 413 More actions · Answer 5

I had dts installed, before. And I used it very often. But problem appears after installing some hotfixes dealing with integration services. I had also service pack two installed before. I have tried to reinstall service pack 2 but got some errors. Neverthelless, annoying problem was resolved faster than I expected. Thank you guys.