 Hello friends, welcome to SSU redec, social decide and this is continuation of SSIS tutorial. So today we gonna discuss about containers. So what is container and what is sequence container. So let's start with container. So containers are a logical grouping of tasks which allow us to manage the scope of the task together. SSIS containers are controls that provide structure of the package and it support repeating control flows in packages and group tasks into a meaningful unit of work. In SSIS we have three type of containers. First is sequence container, then for loop container and last is for each loop container. So for each loop container is used the most. Today we will discuss about sequence container. What is sequence container and what are the real time use of sequence container. It is used to grouping logically related task together which makes it simple to divide the control flow in a package into group of tasks and containers that we manage as a single unit. So what is the purpose of sequence container. So here I have written six scenarios where we can use sequence container and that is very useful for developing our package. So first is grouping task so that we can disable a part of package that is no longer used. So what it mean go to on ssdT and here I would like to add one more package. Then I wish to rename this package with sequence container. Then here as we can see inside these containers we have three containers. First is for loop container, for each loop container and sequence container. We can drag and drop sequence container. Inside the sequence container we can use multiple data flow task. So this is our first data flow task and this is our second data flow task. Then this is our execute SQL task and this is our execute SQL task. So these four task is a label inside this sequence container. If we have a requirement where we want to disable all these task then there is no need to go to on each task and click on disable. We can simply disable our sequence container so that all these task will be disabled. As we can see once we disable then all these tasks have been disabled. Then our second narrowing the scope of the variable to a container. If we wish to create a variable and scope of that variable will be available inside this sequence container only then we can create. Our third is managing the property of multiple tasks into one by setting the property of the container. Like if we want to manage any property of these four tasks then there is no need to go to on each task and set the property. We can simply set the property of this sequence container then that property will be applicable for these tasks. Next is ensure that all tasks in the container must be executed before next task executed. So it ensures that once we execute this package our sequence container will be executed first. We have one more dataflow task and that is outside the sequence container then once these four tasks will be completed after that next dataflow task will be executed. So it ensures that our four tasks which is placed inside the sequence container will be executed first then our dataflow task will be executed which is available outside this sequence container. Next create a transaction across a series of data related tasks but not on the entire package. Let's assume we have a scenario where we want to use transaction and we don't want to use transaction on entire package. We just want to use transaction inside this sequence container then we have a option by which we can use the transaction for this sequence container and it will be available only for those tasks which is placed inside this sequence container. Bring event handler on a single container where we can send an email if anything fails inside the container. So what it means? Like we have four tasks and if any task will be failed then we want to send an email. There is no need to go to all these four tasks and send the property to send email if that task will be failed. We can only set the property for this sequence container if anything will be failed inside the sequence container then mail will be sent. So these are the scenarios by which we can use sequence container. Once we will discuss about the case study then we will see what is the real time use of sequence container and how we can use it. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.