Re: COM object with CLSID {. . . } is either not valid or not register

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 17:20:46 +0100

DTS is a client side tool basically, so have your installed Enterprise
Manager or the redistributable components of DTS on the client machine?

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

"WhiskRomeo" <wrlucasD0N0TSPAM@Xemaps.com> wrote in message
news:EE4C6333-5052-4D1E-8671-28ABA4D8EF02@microsoft.com...
> I have a package that executes fine from the server where SQL Server in
installed.
> However, the below code generates an error (see below code) when executed
from a workstation on the client. This is a Windows .Net application.
>
> All other data access work just fine.
>
> Can anyone explain this?
>
> Bill
> *********************************
> Dim strMsg As String
> Dim strPkgName As String
> Dim oPkg As DTS.Package2
>
> strPkgName = "PPS_BatchImport"
> strDestPath = tbFileToImport.Text
>
> oPkg = New DTS.Package2 '<--ERROR OCCURS HERE
>
> ************** Exception Text **************
> System.Runtime.InteropServices.COMException (0x80040154): COM object with
CLSID {10020202-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not
registered.
> at PPS.frmBatchImport.btnMoveToStaging_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)
>
> --
> William R

Loading