 | |
dotNet and DTS problem
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: dotNet and DTS problem -
04-01-2008
, 08:37 AM
|
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/d...displaylang=en Andrew. "Andrew Baker" <no (AT) spam (DOT) com> wrote in message news:%231p3FSBeIHA.1824 (AT) TK2MSFTNGP02 (DOT) 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 |
#32
| |||
| |||
|
|
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/d...displaylang=en Andrew. "Andrew Baker" <no (AT) spam (DOT) com> wrote in message news:%231p3FSBeIHA.1824 (AT) TK2MSFTNGP02 (DOT) 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 |
#33
| |||
| |||
|
|
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/d...displaylang=en Andrew. "Andrew Baker" <no (AT) spam (DOT) com> wrote in message news:%231p3FSBeIHA.1824 (AT) TK2MSFTNGP02 (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.