 Hello, welcome to SSUnited social decide and this is continuation of SSIS tutorial. So today we gonna discuss about execute package task. In our last video we have discussed about execute process task and today we will discuss about execute package task. So let's start with execute package task. So what is execute package task and when we can use it. So it allow us to execute a package from another package and here we can also pass the parameter from our parent package to child package. So in this video we will discuss how we can execute package from another package. In our next video we will discuss how we can pass the parameter from parent to child package. So go to on ssdT and let's understand how we can execute package from another package. So here let me create one more package then call this package as parent package. So this is our parent package. I need to create one more package and call this package as child package. So this is our child package. So what our plan? Our plan is we want to execute our child package inside the parent package. So for testing let me drag and drop the script task then double click on this script task then click on edit script and here we will write our code. So here we just want to display a message. So we can use message box dot so and inside we can write this is our child package. So we can save it and close it and click on OK. So independent we can execute our child package and we want to execute this child package inside the parent package. So go to on parent package and here so let me drag and drop execute package task then simply double click on this execute package task go to on package and here we can see project reference and external reference. If our child package is available inside our project then we can select our project reference. If our package is not available inside the same project then we can use external reference. In external reference we will get two options first is SQL Server second would be file system. So this time I would like to use project reference because our child package is available inside the same project then here we need to select our child package. So this is our child package we can select and click on OK or save this package and execute. So once our package will be executed then it will move to a child package and it will display the message which we have written. So that is our child package. Now we can click on OK stop this package and go to on parent package and in parent package we can also use a script task and we can connect with execute package task. Now double click on this script task then click on edit script and here we will write the message like we are in parent package. So message box dot so then we can write this is our parent package now we can save it and close it click on OK now we can save our package and execute. So first it execute our child package and click on OK then it will move to our parent package and this is our parent package click on OK. Our package executed successfully so let me disable these tasks and I want to drag and drop one more execute package task and this time I would like to use external reference. So double click on this execute package task go to on packages and here we can select our external reference here we can see we have two options SQL server and file system. So I haven't discussed about the deployment once we will discuss about the deployment then we will understand about the SQL server. So here we are going to use file system then it will ask about connection manager so click on new connection. So here our package is available in the same project but I would like to use as external reference so we want to execute our child package so we can browse. So here we can see this is our child package we can select and click on open click on OK so we have done it now click on OK now let me execute this parent package so as we can see it will move to our child package and executed our child package click on OK and stop the package. So here we have discussed about the how we can execute our child package in our parent package with project reference and external reference in our next video we will discuss about how we can pass the parameter from parent package to child package. 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.