DTS Package throws error on Client Machines only

From: WhiskRomeo (wrlucasD0N0TSPAM_at_Xemaps.com)
Date: 06/11/04


Date: Fri, 11 Jun 2004 15:59:01 -0700

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? Why would we have to register a COM Object?

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