DSXchange

I have a job where using transformer update a table and after the update need to send a notification to other server using FTP with a table name. This FTP should go when ever the update is successful on Table. How do we achieve this, i tried using Link Output variable validating Update Link SQLSTATE = 0 , it didn't work. If i don't provide any constraints FTP process is working with the number of records which got updated in Table, but my requirement is just sent one row with Table name.


Thanks

Consider setting up the FTP as a shell script invoked from an after-stage or after-job subroutine. Within that routine you can make your success tests to decide whether to invoke the script. The table name can be supplied (possibly as a job parameter) through the Input Value field when invoking the subroutine, and as a command line argument ($1) to the shell script.

I would echo the string to a file ahead of time and then ftp it if succesful.

Create another job only for FTP and in the sequence trigger it when ever previous job successful.