 Hello, welcome to SSU Tech, so see this site and this is continuation of SSIS tutorial. So today we gonna discuss about file system task and this is very important task in SSIS. So let's start with file system task. So what file system task does? So it is used to perform different kind of operations on files and folders. Like we can create any folder, we can delete any folder and we can copy and paste any folder. So these are the operations which can be used by file system task and we will discuss one by one. So first is create directory. So go to on ssdT and here I would like to add one more package. Then I wish to rename this package with file system task and I would like to drag and drop file system task. So this is our folder inside this folder I would like to create one more folder with the name of temp. So how we can create? So double click on this file system task. Here as we can see inside this operations we have many more options. So I would like to create directory. Then in source connection we have two types. First we can store our connection in a variable and then we can use that variable directly or we can make connection directly over here. So first time I would like to create connection directly. So new connection. In usage type we have four types. So I would like to create a folder so we can select and here we need to specify the path with the folder name. So this is our path I want to copy and paste it here and I want to create folder with the name of temp. So we need to specify folder name as well. Now click on OK again OK. So this is for creating folder. So once this package will be executed successfully our temporary folder will be created. So I can click on start. As we can see package has been executed successfully and temporary folder has been created. Once our folder has been created successfully again we need to execute our package then it will throw an error like our directory is already exist. So how we can remove this double click on this file system task. Here we have an option for use directory if exist. So we need to select as true now click on OK and we can save our package and execute. So package will be executed successfully and there is no any change in our directory. So stop our package and I would like to disable this package and drag and drop one more package and this time I would like to delete the folder. So I can rename with delete folder now double click on this delete folder go to our operations here I want to delete directory. So here as I have already made the connection with our temporary folder so I want to use that one now click on OK. Once our package will be executed then temporary folder will be removed click on start. So as we can see package has been executed successfully and folder is deleted now we can stop this package. So this is for delete any directory now we can disable our third operation is copy directory. So need to drag and drop file system task and go to our folder. First of all I would like to add a new folder. So this is our temporary folder. What we want to do once our package will be executed then this folder will be copied in this folder go to SSGT double click on this file system task. So here we need to configure two connections first for the source and second for the destination. So go to own copy directory then here we can see this is our source. So our source would be temp as we have created second we have destination. So in destination we need to make the connection so click on new. So here we need to use create folder and copy this destination path and paste it here and we can rename at runtime. So I want to use temp one now click on OK again OK. So once our package will be executed then temp one folder should be created in this folder so I can click on start. So package has been executed successfully and temp one folder has been created and this is for copy so we can use copy folder and our third operation has been completed and our fourth delete directory content. So I want to disable this file system task then drag and drop new file system task. So what our plan to do we want to delete all the content which is available inside this folder. So go to own SSGT now double click on this file system task inside this operation we have an operation with delete directory content. So here we need to make our connection so this is our folder path we can copy and we need to click on new connection our existing folder now we can paste now click on OK again OK. So once our package will be executed then this directory will be empty so click on start. So package executed successfully as we can see this folder is empty now we can stop this package and this is for delete content and this is our fourth operation so we can disable file system task and move to our next. So next is copy files go to on SSGT need to drag and drop one more file system task this is for copy files so we can rename with copy files. So our plan is so I would like to copy this Excel source file inside this folder so go to on SSGT now double click on this file and our operation should be copy file go to on source connection and click on new connection we need to select existing file then here we need to copy folder path with file name now we can paste it here and click on OK. So we have configured our source and in our destination where we want to copy this file so click on new connection and here I would like to create file so we need to select on create and this is our folder where we want to create a file we can copy this folder paste it here and we can put a name with source Excel SSGT. So once our package will be executed file will be copied in this folder and rename with source now click on OK again OK now we can save your package so once our package will be executed our file should be copied in this folder so click on start and we will check as we can see package has been executed successfully and file has been copied so we can open this file and here we are having 7 rows now we can close this file and go to inside this folder and open this file so here again we are having same metadata as we are having in source file so this is our 5th operation in our 6th operation we want to delete the file so how we can delete the file so go to on SSGT and stop this package and I want to disable this and need to drag and drop one more file system task and this is for delete files now double click on this delete file and inside this operation we need to select delete file so this is our delete file here we need to make the connection so this is our file so I would like to copy this folder path with file name now here I would like to add one more connection existing file that is fine so we can paste it and click on OK now click on OK so once our package will be executed then this source file should be deleted now click on start so package executed successfully and file has been deleted now we can stop this package next we are having move directory move files rename files and set attributes so we will cover these 4 operations in our next video 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