SQL Server scheduled job fails
I believe I'm running into a problem similar to the one described in this forum post:
However, I've followed the instructions in that post and my problem persists. Here are the details:
SQL Server 2000
WinSCP 4.1.9 (Build 416)
I am running a SQL Server DTS package which includes an Execute Process Task. The Execute Process Task calls the Win32 process D:\WinSCP\WinSCP.exe (WinSCP is installed at the root of D: on this machine). The Win32 process is passed 3 parameters: /console /script=Upload.bat /log=myerror.txt. Upload.bat does the following:
option batch on
option confirm off
option transfer binary
ADSync.csv is a file that the DTS package creates prior to running the Execute Process Task. The file is created without a problem. And, the Execute Process Task will run if I execute the DTS package manually, or if I run the WinSCP.exe with the appropriate parameters in a command line. However, when the DTS package is scheduled as a job, it fails. It doesn't create the myerror.txt logfile, so it's difficult to know what the problem is. As outlined in the above-referenced post (https://winscp.net/forum/viewtopic.php?t=7538), I have changed the WinSCP storage configuration to the INI file, the INI file is in the WinSCP directory, and our DBA assures me that the SQL agent has access to the WinSCP directory (our SQL agent has admin rights).
What could be causing this behavior?
Thanks very much!