I (re)searched several threads on FTP and found a lot of horror stories. Often times, it turns out that the best approach would be to use command line FTP and then get on with the actual job.
My requirements are as follows.
1. Server Job1 creates an XML file from a datbase table
2. An "After-Job" step compresses this XML file into a ".ZIP" file. (Only if the Job was successful)
3. If the "Zip" file was created, then need to FTP this to another server.
4. Send an email notification to predefined list of users/support team.
At this time:-
I desgined and tested Job1 and it works fine.
I created a Sequence Job to invoke Job1. Job1 has the zipfile name as a job parameter.
I have setup a notification activity and that works fine too. (Just runs Job1 and notifies users. No FTP yet
)I am not clear how to plug the filename from Job1 into another job that would perform the FTP operation.
Right now, I am thinking of using the FTP stage in another Job called "Job2" and having it do the FTP. I am trying to understand the FTP stage properties.... and not clear on why one should provide all those column information. All i need to do is upload ONE file.
OR should i use the ExcecuteCommand in the Sequence canvas, push the "Zip" file and be done with it. In this approach, how much error handling can i support?
In either case, what are the mechanisms to pass the file name from Job1 to another job? Should i save such inter-job parameters in a global space?
Apologies for loading this .... I can split this into multiple posts, if required
Thanks in advance,
</a>