How can we implement squence of execution at control flow level , where it specifies 1 run the sequence container 1 then 2 the nrest. Same way how can we provide for data flow. with example would help. Navin.D http://navind.spaces.live.com/

Use precedence constraints. The little arrows you get at the bottom of every control flow object, you can drag them to link containers. Perhaps watching a few online training videos may help you get started with SSIS. Integration Services Videos (SQL Server 2008)http://www.sqlis.com | http://www.konesans.com

Can we manage engine thread sequence, if so how?Navin.D http://navind.spaces.live.com/

Can we manage engine thread sequence, if so how? If by "Engine thread sequence" you mean sequential execution within data flow task, then I don't think you can manage the execution order within a data flow task. To implement such a requirement you can use different data flow tasks and manage their execution order using precedence constraints. Nitesh Rai- Please mark the post as answered if it answers your question

How can we implement squence of execution at control flow level , where it specifies 1 run the sequence container 1 then 2 the nrest. Same way how can we provide for data flow. with example would help. Navin.D http://navind.spaces.live.com/ You can't, and nor should you be able to. The dataflow is an atomic unit of work - there is no concept of workflow inside a dataflow. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me