I need to select some data from SQL regularly. Each row of the data selected has its own big integer id. Each next run should select new data only, after id already selected in the previous run. So I want to try to read it before select and store the new id after select. Before the first run I assume that id == 0.
I plan to store the id in the properties or ini or plain text file which contain only this id.
What is the preferred way to do this? One job for a file checking plus one transformation for selecting data or I can do this using one transformation only?