unable to transfer files usin SFTPconnection via informatica :: Support Forum

tanvi jain
Joined:: 2014-07-30
Posts:: 1

unable to transfer files usin SFTPconnection via informatica

2014-07-30 07:11

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

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,506
Location:: Prague, Czechia

Re: unable to transfer files usin SFTPconnection via informatica

2014-07-30

Please read:
https://winscp.net/eng/docs/faq_scheduler

If you want more specific answer, please provide more details on "it is not executing".

Reply with quote

Siddharth Guest

Re: unable to transfer files usin SFTPconnection via informatica

2014-07-31 13:05

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

martin◆ Site Admin

Re: unable to transfer files usin SFTPconnection via informatica

2014-08-01

Please see https://winscp.net/eng/docs/reporting#howto

Reply with quote

Guest

2016-07-12 22:34

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
Joined:: 2002-12-10
Posts:: 41,506
Location:: Prague, Czechia

2016-07-14

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

unable to transfer files usin SFTPconnection via informatica