Topic "unable to transfer files usin SFTPconnection via informatica"

Author Message
tanvi jain
[View user's profile]

Joined: 2014-07-30
Posts: 1
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
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24552
Location: Prague, Czechia
Please read:
http://winscp.net/eng/docs/faq_scheduler

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

Guest


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
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24552
Location: Prague, Czechia
Please see http://winscp.net/eng/docs/reporting#howto
_________________
Martin Prikryl
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
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24552
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
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License