DSXchange

Keep in mind the fact that the before and after tabs are completely isolated from the 'main' processing the stage does. Just because you are deleting from the right place 'before' and inserting to the right place 'after' has no bearing on what goes on in the stage. Other than the fact that they all share the same connection information, however.

Make sure the table name is fully qualified in all instances, so there's no possibility of using a local table or a synonym rather than the table you think you are populating.