Some time ago I was engaged in building Data Warehouse (DWH) for NAV database. To develop incremental data transfer I used system field timestamp, which is present in every NAV table. I build the table, called Timestamp Settings in DWH with the following structure:
Where CompanyID is the index of NAV company in DWH.
When the SSIS package launches, the script task, which reades the last timestamp values, is fired.
When the SSIS package launches, the script task, which reades the last timestamp values, is fired.
