Post reply

Update source table from DTS package

  • July 15, 2003 at 8:57 pm

    #106340

    What's the best way to update a field in a source table from a DTS package - i.e. set an "Exported" bit field in the source table to true, so I only query on unprocessed rows?

  • July 18, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 21, 2003 at 6:37 am

    #466188

    Why not in your DataPumpTask or DataDrivenQuery Task use the lookup to update the source record to reset your "exported" field in the OnInsertSucessPhase of the transformation.

    - Tom.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply