I have a requirement where I need to fetch data from multiple DB tables based on transfer_flag as "N" and write to individual files and then FTP to a particular server. Once the transfer is done, I need to update the transfer_flag as "Y" for all these records. I was planning to use tDBRow where I would write the query to set transfer_flag as "Y" for records having transfer_flag as "N". But this may result in an issue as the transfer flag for the records which were newly updated/inserted into the table at time of processing will also be set to "Y" even though those records are not transferred via FTP,
Please let me know how to handle this situation as I don't want to use tDBOutput Component as this will result in more time to update based on key columns.
