 Hello, welcome to SSUnited, so stay on the side and this is continuation of SSIS tutorial. So today we gonna discuss about execute process task. So let's start with execute process task. So what execute process task does? So it is used to run an application or batch files. So we can use to open any standard application like Microsoft Excel or Microsoft Chico Server, run business applications or batch files. It can be also used to compress or expand any files. So here our first case study, we just want to open any notepad file and then in our second case study, I would like to copy any folder from any specific location to other location. So this is our text file and I would like to open this file once our practice will be executed. So go to our SSGT and here, let me create one more package and then call this package as execute process task. Here I would like to drag and drop execute process task. Then double click on this execute process. Go to on process. Inside this process, we can see we have executable. Here we need to specify what we want to do. So we want to open notepad. So we need to specify notepad.exe file. Then inside this argument, we need to specify our file path. So this is our folder and what is our file and our file is this text file. So we can copy and paste it here. That is fine. Now in our working directory, we can specify our directory. So this is our directory. That is fine. Now in our window style, we can see it has options for normal, maximized, minimized and hidden. So I am happy with normal. Now click on OK. So once our practice will be executed, then that notepad file should be opened. So click on start. So here as we can see, text file.txt has been opened and this practice will be running until this file will not be closed. So let me close this file. So our practice has been executed successfully. Now stop this practice and let me disable this execute process task and so let me drag and drop one more execute process task. So here what our plan? So here we have a source folder. So in this source folder, we are having files and subfolder. So we want to copy all these files with the subfolder and we want to paste in destination. And here we don't have any data. So how we can do this? Go to on ssgt, double click on this execute process task, go to on processes. Here we need to specify executable. That would be xcomp.exe. Then we need to specify our source path. So that is our f then sources. So this is our f directory. Then we have sources folder. So this is our source. What we want to copy? We want to copy all the files. Then where we want to copy? We want to copy inside the destination folder. So this is our destination folder. And then we need to specify slash with s. So it will copy all the files with the sub directory. If we are not going to specify slash with s, then it will not copy the sub directories. Now click on OK. So as we can see, initially we don't have any file in this destination folder. So let me execute the package. So package executor successfully and here our data have been copied. Now stop this package. In our next case study here, we can jib the file and we can also unjib the file. So how we can do the jib go to inside this source folder and we want to jib txt file. So go to on sdt and let me disable this execute process task and drag and drop one more. So this is for the jib. That is fine. Now click on this execute process task go to on processes. Inside this executable, we need to specify. As I am using 7 z. So this is our executable file. In the argument, first we need to specify a because we want to jib. After that, we need to specify minus t7 z. After that, we want to specify our path. I want to jib the file inside the source folder. So this is our source folder. And then we need to specify jib file. So that is our text file text dot jib. After that, we need to specify our path where we will get the file. So we will get the file from this source and text file dot txt. Then in working directory, we need to specify f with source. So it is showing error 7 z dot xc not available. So we need to specify our full path. So it is available inside the c, then program files, then 7 minus jib. So this is our full path. Click on. Okay. Looks good. Now execute a package. So package executor successfully. So you stop this package and go to on the folder. So here as you can see, we are getting the jib file. So this is for the jib. So how we can do the unjib this text file. So go to on ssgt and let me disable this execute process task as well and drag and drop one more. And this is for the unjib. So this is a unjib. Now double click on this go to on process. Here we need to specify full path that is our program file, then 7 z.execute. In argument, we need to specify e for the unjib. Then we need to specify folder path with the file name. So this is our jib file. Let me copy this and paste it here. So inside the working directory, I just want to use source, now click on okay. Then go to in the folder and here I would like to delete the file. So once our package will be executed, then our file will be unjibbed now click on start. Package executed successfully, stop this package and go to on the folder. And here we can see we are getting the file. So I hope you have understand how we can use the execute process task. So by using execute process task, we can copy the folder and paste in other location and we can also jib and unjib the file according to our requirement and we can also open the standard applications. 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.