> 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.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,
> Ami

> 0x80070005
>

"Allan Mitchell" wrote:

> 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 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.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,
> > Amir
>
>