DTS Package And Schedule Job

Hi ,
I create a DTS package to run a SQL Task. This task will call a batch
file. This batch is to unzip the specified file. It works fine in the DTS
design enviroment but after I scheduled this package , it failed to run.
I try to schedule this batch is the windows scheduler , it works fine.
Any idea on it ?
Travis TanYour SQL Agent permissions are likely the culprit...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:9D9913AE-214A-4D76-9BD5-F1B5251A7993@.microsoft.com...
> Hi ,
> I create a DTS package to run a SQL Task. This task will call a batch
> file. This batch is to unzip the specified file. It works fine in the DTS
> design enviroment but after I scheduled this package , it failed to run.
> I try to schedule this batch is the windows scheduler , it works fine.
> Any idea on it ?
> --
> Travis Tan