"Lynn" <anonymous@discussions.microsoft.com> wrote in message
news:004801c39fc4$8ec5cd00$a101280a@phx.gbl...
> I have created a DTS package which copies data from a
> table on server1 to a table on server2. The data is being
> overwritten. If I execute the package everything works
> fine.
>
> However, if I try to schedule the package via a job the
> table is left empty, i.e., the old data is being deleted
> but the new data is not being populated. The job shows
> completed successfully.
>
> Any ideas on why the package works but not via a scheduled
> job.
>
> Thanks!