Hi
I have a WinForms client which needs to execute a DTS Package on SQl Server
2000. The Sql Server db is on a server. If I run the client on the server it
executes the package ok, however If I run the client from a remote PC, the
OnQueryCancel event gets fired before the execute and the the event log has
the following error:

In OnError : Event Source : DTSStep_DTSDataPumpTask_1 Error Code :
-2147467259 Source : Microsoft OLE DB Provider for SQL Server Description :
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. HelpFile : HelpContext : 0 InterfaceError
{0C733A8B-2A1C-11CE-ADE5-00AA0044773D}

not sure how to resolve this, any help would be greatly appreciated.
thanks

Hello parag,

Remember the package will come to you so wherever you say "Go" is where the
package will execute. It looks as though the remote PC cannot see/access
the remote server in step DTSStep_DTSDataPumpTask_1


Allan

Hi Alan

thanks for the response..
Does that mean that I cannot load and execute a DTS Package from a remote
server locally on a client PC? Is there anyway I can achieve this?

Parag

"Allan Mitchell" wrote:

Hello parag,


You can load a package from a remote server sure look here though

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


If you want the package to execute actually ON the remote server then look
at firing off a job that fores the package

Allan

Hi Allan

Thanks for the prompt reply. In that case one of the options would be to use
a webservice which is hosed on IIS on the same server as the SQL Server. This
webservice would then load the package and execute it. My client would call a
method on the webservice to execute the package.
If I do this how can I update a progress bar on my client?

The setup would be :

C# WinForms Client --> calling a method on the webservice on IIS6.0 -->
executea a package on SQL Server 2000.

thanks for the help

"Allan Mitchell" wrote: