"Peter Ramsebner" <p.r@pr.com> wrote in message
news:eVx1DKJ7DHA.3420@TK2MSFTNGP11.phx.gbl...
> 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@pr.com> wrote in message
> news:eVx1DKJ7DHA.3420@TK2MSFTNGP11.phx.gbl...
> > 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
> >
> >
>
>