Koen Verbeeck (12/18/2013)
kapil_kk (12/18/2013)
Abu Dina (12/18/2013)
+1 to Koens's suggestion.I like to keep things simple so I would link the Data Flow Task to an Execute SQL Task (with On Success precedence constraint) that contains your UPDATE statement.
I am also thinking doing in that way only but little confuse that If I write query using Precedence constraint as Succees in ExecuteSQLTask as
Update table1
Set StatusFlag = 1
Then does it update only those rows which comes from source for StatusFlag = 0 or it will update the statusflag = 1 for whole table...
It will update the entire table.
Again, clear requirements please.
I have to transfer data from table1 to table2 which has same structure.. From table1 only those rows should get transferred whose statusflag = 0 to table2. After data gets transferred change the status flag to 1 for those rows... I think now its get cleared to you
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/