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.Lo adData()

at Decipher_Mega_Table_Uploader.LoadMegaTableStep3.bt nNext_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(MouseEventAr gs 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(M essage& m)

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

Any idea?

Thanks

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

Simon