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

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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/archi...28/540780.aspx

Hope it helps,
RLF

"Andrew Baker" <no (AT) spam (DOT) com> wrote

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.


"Russell Fields" <russellfields (AT) nomail (DOT) com> wrote