I created the below mentioned batch file and the script to transfer files from local server to remote FTP server using SFTP connection via Informatica Workflow.
The batch file works fine when run manually. But it is not executing when run via Informatica Workflow. Please help me out with it.
Batch file and script is present in E drive.
WinSCP is installed in C drive.
Informatica version is 8.1.1.
@echo off SET WorkingDirectory=C:\"Program Files"\WinSCP %WorkingDirectory%\winscp.com /script=CRD_FTP_Script.txt
# Automatically abort script on errors option batch abort # Disable overwrite confirmations that conflict with the previous option confirm off # Connect open sftp://email@example.com/ # Change the remote directory cd /f002 cd sftp cd cmsftpdm cd in cd cir cd vrm cd live # Upload the file to current working directory put E:\PFZVRM\CMS_CIR\Outbox\*.xml # Disconnect close # Exit WinSCP exit