Hi all,

following situation:
There are 2 sql servers (2000) in a LAN and there is my notebook with a
local sql server connected via a vpn tunnel to this LAN.

On my notebook i have registred all servers in enterprise manager.
Now i have created a DTS Package to transfer a Database from one server to
the other and i have save the package on the target server.

There are a lot of troubles:
1) the script which will be used is saved on my notebook and not on the
server on which is the package saved.
2) the package will be executed on my notebook and not on the server on
which it is saved
3) and so all of the data will be copied from the source server over the vpn
tunnel to my notebook and from there back to the target server (well, there
are only 1500MB to copy)
4) you are not able to execute the package on the server on which it is
saved because the script is on my notebook


Thanks for any help


Peter

Did you ask a question there?

Move the script to the server and the package to fire implement as a job
step on the server. Exec sp_start_job to fire the job.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Peter Ramsebner" <p.r (AT) pr (DOT) com> wrote

But you have to save the script on the server in exactly the same directory.
But this directory does not exist.
I can't find any property in the package to change the script directory.

Any idea?

Thanks Peter



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> escribió en el mensaje
news:u3CdGgJ7DHA.3360 (AT) tk2msftngp13 (DOT) phx.gbl...