SSIS: How to transfer data from table A to table B and then update table A flag column for each row

views:

102

answers:

SSIS: How to transfer data from table A to table B and then update table A flag column for each row

Hi,

I need to crate a package in SSIS which will selectively transfer data from Table A to table B based on a flag in Table A and after the transfer update the flag in Table A.

Please advice on the approach to this scenario and the different ways in which this can be done effectively.

I would also like to mention that i have never worked on SSIS packages before.

+2 A:

DFT : Source : Select query where Flag filteration

Execute SQL: Update statement with same flag codnition

Swaroop 2010-05-11 11:03:02

The only problem that i see with using Execute SQL task is - what if rows get added to the table after DFT started running? Exec sql task would "mark" them as processed without loading them into table B. I think using a Multicast in combination with SQL Command component and running inside a transaction would solve the problem.

unclepaul84 2010-05-11 14:38:58

Using an OLE DB Command invites poor performance. Use a Data Flow Task followed by an Execute SQL Task as suggested. Place both in a Sequence Container, and "require" a transaction on the Sequence Container.

Todd McDermid 2010-05-12 05:57:16

ansaurus

tags:

views:

answers:

SSIS: How to transfer data from table A to table B and then update table A flag column for each row

related questions