unable to transfer files usin SFTPconnection via informatica

Advertisement

tanvi jain
Joined:
Posts:
1

unable to transfer files usin SFTPconnection via informatica

Hi,
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.


CRD_FTP.bat

@echo off
SET WorkingDirectory=C:\"Program Files"\WinSCP
%WorkingDirectory%\winscp.com /script=CRD_FTP_Script.txt

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://cmsftp@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
_________________
Regards,
Tanvi

Reply with quote

Advertisement

Siddharth
Guest

Re: unable to transfer files usin SFTPconnection via informatica

Hi,

<< this is in extension to the original post >>

We are unable to transfer the files using the SFTP connection. The above batch file copies the file to the target when executed individually. But when we try to call the same batch file using informatica, it is unable to do the needful.
I understand that Informatica 8.1.1 doesn't have an option to establish SFTP connection. We can only see the FTP connection when checked in Connections tab

Any pointers on this please.

Reply with quote

Guest

Hi Guys,

Can we execute the FTP batch script using Informatica job?

Actually i tried running the batch script manually using windows cmd it is working fine but when i tried to run the script from informatica cmd task it is failing with exit code [1]. So, could anyone help me out to resolve the issue. Below is the windows batch script i'm using.

SET PATH="C:\Program Files (x86)\WinSCP"
WinSCP.com /script=D:\Informatica\9.5.1\server\infa_shared\scripts\FTP_OW.txt
exit

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
27,227
Location:
Prague, Czechia

Anonymous wrote:

Actually i tried running the batch script manually using windows cmd it is working fine but when i tried to run the script from informatica cmd task it is failing with exit code [1]. So, could anyone help me out to resolve the issue. Below is the windows batch script i'm using.

SET PATH="C:\Program Files (x86)\WinSCP"
WinSCP.com /script=D:\Informatica\9.5.1\server\infa_shared\scripts\FTP_OW.txt
exit
Start here:
https://winscp.net/eng/docs/faq_scheduler

Reply with quote

Advertisement

You can post new topics in this forum