Execute Remote DTS-Package on different Server

Hello DTS discussion group,

i'm going crazy with one maybe simple problem on executing DTS on
SQLSERVER 2000.

Situation:
I have in my local environment a DTS-Package, which starts another DTS-
Package. I used
both dtsrun as command line task and the exisiting Execute Package
Task from DTS-Designer.

The second DTS-Package is on another network. All i want is, that when
i start my local
DTS-Package, that this package starts the package from the remote
server. This package
on the remote server should collect some data and should do some
actions.

At this point it looks like, the second dts-Package which i want to
start with my first package,
will be executed not in the remote server environment. It looks like
it starts like my local package in
my local environment. I always get error messages which tells me, that
some database connections
are not probably set correctly. But when i execute those remote
packages directly in the
remote server environment via terminal server etc. all kind of things
will work fine.

Maybe someone can gibe me an hint, how to solve this problem, so that
this second package
will be executed in remote server environment, not in my local
environment.

Greetings

w.stefan

Hello w.stefan,

You execute the package using DTSRun. The package comes to you. The fact
the package is stored (and that is the key word here) is immaterial. To
do this remote execution a common method is to fire a job on the remote server
that executes the package.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

> Hello DTS discussion group,
>
> i'm going crazy with one maybe simple problem on executing DTS on
> SQLSERVER 2000.
>
> Situation:
> I have in my local environment a DTS-Package, which starts another
> DTS-
> Package. I used
> both dtsrun as command line task and the exisiting Execute Package
> Task from DTS-Designer.
> The second DTS-Package is on another network. All i want is, that when
> i start my local
> DTS-Package, that this package starts the package from the remote
> server. This package
> on the remote server should collect some data and should do some
> actions.
> At this point it looks like, the second dts-Package which i want to
> start with my first package,
> will be executed not in the remote server environment. It looks like
> it starts like my local package in
> my local environment. I always get error messages which tells me, that
> some database connections
> are not probably set correctly. But when i execute those remote
> packages directly in the
> remote server environment via terminal server etc. all kind of things
> will work fine.
> Maybe someone can gibe me an hint, how to solve this problem, so that
> this second package
> will be executed in remote server environment, not in my local
> environment.
> Greetings
>
> w.stefan
>