Page 1 of 1

FTP XML File to

Posted: Wed Aug 01, 2007 9:29 pm
by ds2000
I want to FTP two xml files created by datastage jobs to remote server. Never done before ftp. Any suggestions.

Posted: Wed Aug 01, 2007 11:30 pm
by ray.wurlod
Learn FTP.

Posted: Thu Aug 02, 2007 6:04 am
by chulett
Short but correct, regardless. You'll need to 'script' the ftp of the two files to your remote server. If you don't know anything about ftp, is there someone there where you work who does and would be willing to write the required batch file for you? Or try to Google up some examples. Manual FTP is pretty straight-forward and something you could learn on your own rather easily, it's the scripting part that seems to throw people.

You can get some samples of the 'here document' style one would use on a UNIX server to do the same task by searching the forums here, unfortunately I'm unsure how one would do the same in a Windows batch file. :(

Posted: Thu Aug 02, 2007 6:10 am
by ds2000
ray.wurlod wrote:Learn FTP.
I have read it and have questions:

a) As i read "File Transfer plug-in, extracts data from, or writes data to, a single text file".
So can i use xml files to ftp using plugin ? For xml files do i have to use folder stage as input to ftp?

Posted: Thu Aug 02, 2007 6:20 am
by chulett
Ray said 'FTP' not 'the FTP Stage'. You'll find the stage problematic for things like XML files as the stage is metadata driven and will want to transfer the files one 'record' at a time. While you may be able to get it to work if you haven't formatted the XML output, you're better off learning and using command line ftp for this.