i got round mine by creating a temp table, loading all "updated" rows as an insert into the temp table.

then in the flow, add an Execute SQL Task. blah blah...

i'm trying to do the exact same thing.

so far i have an OLE DB Connection, LookUp (Expression), Conditional Split, OLE Destination for Insert New Rows, and an OLE Command for...