SQL Server Performance

SQL DTS package - System.Runtime.InteropServices.C

Discussion in 'SQL Server DTS-Related Questions' started by yootaeho, Mar 29, 2005.

  1. yootaeho New Member

    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?

  2. dineshasanka Moderator

    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

Share This Page