> I am using MS SQL Server 2000 Standard Edition with SP3a. I have
> created a package to FTP some files from our Mainframe to a local
> directory on the same SQL Server box. I have scheduled the package to
> execute at a specific time everyday using the job scheduler in MS SQL
> Server. The job reports that it ran successfully but it does not
> download the files request in the FTP process.
>
> When I run the DTS package manually all works as expected. This is
> running on a Windows 2003 R2 Server with SP1. If I set this up to run
> via Windows task scheduler using similar dat files it works every
> time.
>
> If any knows how to get past this problem I sure would appreciate
> hearing from you.
>
> Thanks in advance.
>