…but succeed when run manually at command prompt..
We have a vbs script that access an ftp sites and ftp some files. This vbs script is executed using SQL job via xp_cmdshell and cscript. After we upgrade the server from Win server 2000 to 2003, the job execute the vbs but no file is being ftped to the server. but when executed manually using cmd prompt and cscript, the files are being copied.
any thoughts will be appreciated. Let me know if you need more info.
these are the object being used in FTP:
‘ Create objects
Set wsh = CreateObject(“Wscript.Shell”)
Set fs = CreateObject(“Scripting.FileSystemObject”)
is there any incompatibility on these objects to win Server 2003? I am not sure why it is not working when executed as SQL job but OK when executed manually.