You are currently viewing the BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
When storing the date back into the table the authors use the oldest date in the data tables as the last change date.
Would it not be just as valid to store the current date/time as the last change date to be used as the starting point for the next incremental data run?
Ch 3 - incremental data loading
Linear Mode
