Execute tasks in parallel 1

[walidwalid]

I have an integration services package that has one data flow task contains one OLEDB source, multicasting task and 3 OLEDB command tasks to update some rows in the same table but with different conditions. My question is how to make those tasks run one after one, i mean i want to make the OLEDB task finishing first and then the multicasting task after that and so on.cause i found that the tasks work in parallel and i don't want that.

Please reply.

Thanks for the forum and for the members.

 

[MDXer]

First off the OLE DB command task should be avoided. a better and more effecient method is to output the rows to be changes to a table or tables and then execute a SQL Task to call a procedure or a T-SQL script in the task to execute the update.

The reason for this is that the OLE DB Command task executes once for every record that passes through it. By out putting your rows to a table you can preform a set based update which SQL will preform for effeciently.

 

[walidwalid]

i think your solution is better.It works now
Okay, Thanks a lot