Decision Stream: FTP possible? 1

[Loukas]

I have used the SQLTXT Designer in Decision Stream which I find very easy in use and provides good functionality.

Please assist in the following:
In case that my TXT files exist in a remote location is it possible to use ftp in DS in order to "read" txt files from a remote machine?

Thanks for your answers...

 

[MattOh]

Hi Loukas,
Me again.
I'm presuming you want to FTP the file from the remote machine to your local server before processing it in SQL TXT.

If that is the case, I would suggest you set up a JobStream. Make the first node in the JobStream a Procedure node. In that node, you can call any operating system command (including calling programs)by using the "System" function. For example: System("c:\mystuff.bat&quot.

Hope that helps,
Matt

 

[Loukas]

Thank you, for your assistance MattOh!