DTS & .NET

I have a simple DTS package that is being executed within a .Net application using the MS DTSPackage Object Library. Since I have the SQL Server 2000 desktop tools installed, the package executes with no problems, however, when another user tries to execute it, the following exception is thrown:

Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154

I've tried including all the DTS references, rather than just the Package object reference, and that didn't help.

Thanks in advance for your help. THis is really frustrating.

Hi toneho,

are you using PackageEvents interface?

Can you provide us a sample?

|||0x80040154 is 'class not registered', i.e. DTS is not installed on this machine.
Solution - you need to install it :)

P.S. This is SSIS forum, not DTS.|||

It is my understanding that the DTS forum was changed to the SSIS forum.

So I included the DTS packageobject interop in my application - what more needs to be done to install DTS?

|||

toneho wrote:

It is my understanding that the DTS forum was changed to the SSIS forum.

So I included the DTS packageobject interop in my application - what more needs to be done to install DTS?

Try: http://groups.google.com/group/microsoft.public.sqlserver.dts/topics?lnk=srg|||Interop is just that - interop, that allows you to talk to COM object from .NET code. You need the actual COM object installed - e.g. install DTS from SQL 2000 CD :)