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

Hi Amir,

Are you sure that SSIS is actually installed. SQL Server 2005 is not
like SQL Server 2000 where DTS was installed by default with the data
engine. You should check in the services control panel to see if the
SSIS service exists.

Jonathan


Amir Steta wrote:

Thanks Amir...

Its helped me a lot.

-Muralikrishna

"Amir Steta" wrote: