I have some applications that use ftp to retrieve data in an SQL job. Everything works except I can't figure out how to get ftp to log to a text file. It can be done manually, but not when executed from an execute process task in the DTS package. I've done this on an AS/400 many times. I know it can be done, just don't know how.
I prepare a txt file from a vb script preceeding the execute process task. The execute process task win32 process is: ftp.exe
, the parameters are: -s:c:\ftpCommands.txt
Where do I put the >c:\ftplog.txt redirect command to capture the log?