SQL DTS package – System.Runtime.InteropServices.C | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL DTS package – System.Runtime.InteropServices.C

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(MouseEventArgs 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
May be a delayed answer.
I think this an issue with the accessing of DTS.
Can you tell us how are you accessing the DTS from your applciation