SQL Server Performance

AS400/DB2to SQL Server insert incremental

Discussion in 'SQL Server DTS-Related Questions' started by jwmac0428, Jun 9, 2004.

  1. jwmac0428 New Member

    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 )

Share This Page