Transfer files from one server to other using FTP stage

[pandujoy]

hi,

I am having a problem using FTP entraprise stage.

With in the stage i have used the URL- ftp://host/filepath and added the userid and password.

I ma getting the below error -

is not valid remote file.

not sure....when i using ftp from outside it works...infact its "sftp"....is there any diff. in sysntax for url from sftp n ftp..should we define any specific syntax for sftp

appreciate your help

[pandujoy]

Let me be clear...

Can we achieve getting the files from SFTP server using FTP stage in Datastage 8.0.1

[chulett]

Moderator, please move to the Enterprise forum.

[chulett]

...infact its "sftp"....is there any diff.

Yes, BIG "diff" and no the stage does not support secure ftp.

[pandujoy]

sorry for posting in the wrong forum...

is there a way to get files from the sftp server using datastage

[chulett]

Sure, have DataStage run a script that does the sftp or scp transfer. You will, however, need to set up the proper RSA keys between hosts so this will work in a 'secure' manner. Have that conversation your SysAdmin.

[pandujoy]

Thanks chulett for you reply.

Does it mean that i have to run the script in datastage as EXesh before.

[chulett]

ExecSH before job or Execute Command in a Sequence job or using DSExecute() in a Server routine or... many ways to skin that cat.

[pandujoy]

Thanks a lot chulett. I wrote a script and its running fine