Execution Order Insert & Update

 

hello all,

 

i have conditional split, there 2 outputs.

 

first output dataset inserted database.

 

second output dataset data exists in db. need update data.

 

i have doubt here. want insertion done first , updation.

is there property set insertion or updation, maintains order of execution or priority of execution.

 

please ask me if need further clarification.

 

thanks,

kapadia shalin p.

the easiest way ensure updates occur second put output of updates raw destination file (or temp table) , use data flow (or execute sql task) to execute updates. 

 

why need updates occur second?

 

SQL Server  >  SQL Server Integration Services