title: How the transaction isolation levels in ssis works?
body: <p>I have few questions about ssis transction isolation levels.
           consider a scenario:I have an Execute SQL task which insert a data in a table A.This task is pointing to a dataflow task,which read the data which is previously inserted on A.I have started Distributed transaction and if i set transaction isolation in ssis as readcommited,whether it commit the table A at first execute sql task and move to dataflow task?
  Also what about other isolation level in this scenario?</p>