DTS Package throws error on Client Machines only
From: WhiskRomeo (wrlucasD0N0TSPAM_at_Xemaps.com)
Date: 06/11/04
- Next message: WhiskRomeo: "COM object with CLSID {. . . } is either not valid or not register"
- Previous message: Denis Crotty: "Shapefile import"
- Next in thread: Allan Mitchell: "Re: DTS Package throws error on Client Machines only"
- Reply: Allan Mitchell: "Re: DTS Package throws error on Client Machines only"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: WhiskRomeo: "COM object with CLSID {. . . } is either not valid or not register"
- Previous message: Denis Crotty: "Shapefile import"
- Next in thread: Allan Mitchell: "Re: DTS Package throws error on Client Machines only"
- Reply: Allan Mitchell: "Re: DTS Package throws error on Client Machines only"
- Messages sorted by: [ date ] [ thread ]