dotNet and DTS problem

  • Thread starter Thread starter Andrew Baker
  • Start date Start date
A

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
 
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.
 
Back
Top