sql server dts: Scheduling package on server -- sql server dts

Scheduling package on server

Kayda
1/20/2006 11:44:41 AM

sql server dts: Hi:

Is it true that if you want to schedule a package on the server using
SQL Server Agent, you have to be on the server? If you schedule it on a
remote client it actually runs on that client, similar to running the
package manually from the client.

I always have to get clients to give me a remote connection to their
server if I want to schedule it there, which isn't always possible-so
then they have to do it themselves.

Is there a way to schedule the package from the client so it runs on
the server? If not, can you do this in SQL Server 2005? (Haven't played
with it yet)

Thanks,
Kayda

Re: Scheduling package on server

Allan Mitchell
1/21/2006 2:49:00 AM

Hello Kayda,

I think you are getting two concepts mixed up here.

If you execute a package that resides on a remote server from your workstation
then yes the package executes on your box. If you schedule a package to
execute on a server through a job then the package executes on that server
when invoked by the job.

Allan

[quoted text, click to view]