dotNet and DTS problem

[Andrew Baker]

First, sorry about the cross post but I desperately need an answer.

I have a VB.Net application which uses a SQLServer DTS package which I am
trying to get running on a SQLServer Express host (running Vista). I have
installed the DTS services for 2005 (SQLServer2005_DTS), but the app is
throwing an exception on the instantiating the DTS.Package (or
DTS.PackageClass). I have added the reference in the project to interop.DTS
and I have another identical host where this is working so i am at a loss to
find out what is wrong?

IntelliSense can provide code completion.

Code snippit:

Dim pkg As DTS.Package
Dim iSecurity As DTS.DTSSQLServerStorageFlags
*** pkg = New DTS.Package ***
fails on this line with an exception


Exception System.Runtime.InteropServices.COMException was thrown in
debuggee:
Retrieving the COM class factory for component with CLSID
{10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error:
80040154.

Please help

Andrew

 

[Russell Fields]

Andrew,

Out of my depth here, but searching Technet gives me this:
http://support.microsoft.com/kb/928208/

Here is a note for x64 environments.
http://blogs.msdn.com/karthick/archive/2006/02/28/540780.aspx

Hope it helps,
RLF

 

[Andrew Baker]

Thanks for looking, and while I will investigte this further I dont think it
is the problem.

The exception is thrown while instantiating a new DTS.Package object which
is contained in the DTS.Interop.dll (provided by Microsoft).

Thanks anyway.

 

[Andrew Baker]

AAhh!!!!!!

I found the solution. I had been installing the SQLServer2005_DTS.msi and I
was getting the COMException listed in the OP, but after installing the
SQLServer2005_BC.msi things started to work.

I dont know why the DTS alone would not run DTS but installing the full
backward compatability it now works.

The files are at:
http://www.microsoft.com/downloads/...60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Andrew.