AS400/DB2to SQL Server insert incremental | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

AS400/DB2to SQL Server insert incremental

I want to insert transactions from DB2 for only new records. In all affected tables I have either a date-time field for comparison or a unique incremented transaction number. I would like to use something similar to the where clause in the ActiveX transformation to do this but do not the mechanics. I tried a DoWhile in ActiveX but got errors. Any help would be greatly appreciated.
( where db2 datetime field A > sql server datetime field A )