Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

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
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
Siddharth

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.
martin

Re: unable to transfer files usin SFTPconnection via informatica

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

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

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