There is other process that just insert data to this table where 'Sent' column is '0' when other process insert data to the table. Then from their I have to pull data from the table e.g Select col1, col2,col3 from table where 'Sent' = 0. I didn't understand clearly, you said in first sql task Select col1, col2,col3 from table where 'Sent' = 0. then in second step use data flow task? Where should I update the column 'Sent' = 1? Is this before moving the data to flat file? How to write this? Also, if I run the process again with same data that update the column ' Sent' = 1, is this going to create file with same data again or not? If it is not then that will be right. Please reply.