Microsoft SQL Server forum - SQL DTS package - System.Runtime.InteropServices.COMException

Author

SQL DTS package - System.Runtime.InteropServices.COMException

Leon

2005-03-30, 9:41 am

Hi all,

We have developed a small windows-based application which utilises DTS
package.
And we distributed to our content people who don't have sql server
installed. But they have installed Microsoft Data Access Components
(MDAC) 2.8 on their machine. They can access our database ok but when
the applicatioin comes to use DTS package, this generates the
following errors.

************** Exception Text **************

System.Runtime.InteropServices.COMException (0x80040154): COM object
with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid
or not registered.

at Decipher_Mega_Table_
Uploader.LoadMegaTableStep3.LoadData()

at Decipher_Mega_Table_
Uploader.LoadMegaTableStep3. btnNext_Click(Object

sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button. OnMouseUp(MouseEvent
Args mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)

Any idea?

Thanks

Simon Hayes

2005-03-30, 9:41 am

MDAC doesn't include DTS - check out redist.txt on the MSSQL CD for
details of redistributing the DTS files.

Simon

Sponsored Links