DSXchange

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

Let me be clear...

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

pandujoy wrote:...infact its "sftp"....is there any diff.

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

sorry for posting in the wrong forum...

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

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.

Thanks chulett for you reply.

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

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

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