Thanks for your response Brandie, Phil

i am really sorry for the confusion,

here is bit clear explanation...

all i am using is Data flow tasks, Execute SQL tasks together,

let say i have 20 tasks (10 execute sql tasks & 10 data flow tasks)

upto 14 it is good,

now i added,

15 as dataflow task (fetch data to sql table (Table A) with primary key)

Task 16 is data flow task (it loads data to foreign key table(Table A1) belong to step 15 (Table A))

Task 17 is data flow task (it loads data to foreign key table(Table A1) belong to step 15 (Table A))

18 as dataflow task (fetch data to sql table (TableB) with primary key)

Task 19 is data flow task (it loads data to foreign key table(Table B1) belong to step 18 (Table B))

Task 20 is execute Sql Task to tally unrelated to above steps

so i added a task (execute sql task) before task 15 to check in data any primary key violation data in step 16 sql logic

if it has any violation primary key data then i want to avoid 15, 16, 17 but want to execute 18 onwards normally...

Hope this clear, please let me know if not, i will elaborate more

Thanks in advance

asita