Re: dotNet and DTS problem

Thanks for sharing the solution. - RLF

"Andrew Baker" wrote in message
news:%23r4DOXBkIHA.2276@TK2MSFTNGP05.phx.gbl...
> 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/details.aspx?FamilyID=d09 c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
>
> Andrew.
>
> "Andrew Baker" wrote in message
> news:%231p3FSBeIHA.1824@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>>
>>
>>
>>
>
>