Scheduled DTS Does Not Work Across Servers

Hi,
I was able to successfully create a scheduled DTS job transferring
objects between two databases that Are On The Same Server.
But was unable to have a scheduled DTS job (transferring objects between
different servers)run automatically.
If I execute it manually, it works ok; but not if it's scheduled.
The agent on all servers is started up.
Would very much appreciate your help.
Thank you very much
Mike
*** Sent via Developersdex http://www.codecomments.com ***We may need more security information on this one but looks like this is a
permissions problem.
Supposing that you are using Windows authentication, when you execute the
package you most likely have access to both servers. But when you schedule
it, the user running the job maybe does not have access to the other server.
Hope this helps,
Benjamin Nevarez
Database Administrator
"mike" wrote:

> Hi,
> I was able to successfully create a scheduled DTS job transferring
> objects between two databases that Are On The Same Server.
> But was unable to have a scheduled DTS job (transferring objects between
> different servers)run automatically.
> If I execute it manually, it works ok; but not if it's scheduled.
> The agent on all servers is started up.
> Would very much appreciate your help.
> Thank you very much
>
> Mike
> *** Sent via Developersdex http://www.codecomments.com ***
>|||Purrfect! It worked!
Thank you very much
Mike
*** Sent via Developersdex http://www.codecomments.com ***