Unable to schedule DTS

Unable to schedule DTS for picking up file in shared drive. It creates
table but fails to copy. But if run in em it will execute fine (sql
server 2000)

Re: Unable to schedule DTS

what task are you using in your dts to copy file to table ?

Re: Unable to schedule DTS

I'm copying data from access db to sql server 2000.
rshivara...@gmail.com wrote:
> what task are you using in your dts to copy file to table ?

Re: Unable to schedule DTS

are you logging your dts, so you know where it fails
what task are you using to copy ? transfer data task ?
what is the error message ?