 Hello, Welcome to SSUni Tech, so say this side and today we are going to see one more real-time ADF interview question and answer. So in this video we are going to see how we can archive the file after loading. So here for example we are having a source and that source is the csv file in the blog storage. So first we want to load that data from that csv file to the SQL Server. So after loading the file into the SQL Server we want to archive this file. So we are also having another folder on the same blog storage where we will be going to keep that file. So how we can do that? We will see in this video. So let me quickly go into the browser and here as we can see we are under the input folder. So here the file which is the customer details.csv file and it is having total 4 columns with the employee name, address, department name and gender. Inside the csv we are having the table which is the customer info along with all these details. So we want to load the data from this file to the csv table first and after that we need to move this file from this input folder to this testing folder. So this is the actual requirement and as I told you this is the archival of the file. So the file should not be there inside the input folder. So this file will be moved from here to there. How we can achieve this? So go to on the azure data factor. Here first let me try to create a new pipeline and in this pipeline first we are required to use the copy data activity. So this will be going to load the data into the csv table. So as in the source side we have to click on this new. Go to the azure blog stories, delimited text file. Here we can select the link service that we have already created. Here we can see the file path so we can browse and we can go under the input folder and inside the input folder we will see the file which is the customer details.csv. Now we can click on ok. First row as header click on ok. So we have set up for the source as in delimited text one. So in this thing we want to load the data into the csv table. So here we have to select the azure sql database as an destination. Click on continue. Link service as we have already created the link service and here we need to select the table which is the customer info table. Click on ok. So now it will be going to load the data into the destination table. Second as I told you we have to also move the file from this input folder to the testing folder. So first I want to copy this file from here input folder to the testing folder. So for that let me try to use one more copy data activity and this copy the file from input folder to testing folder. Here we have already created the data set so we can use that that is the delimited text one. So in the sync we have to create a new data set and this is pointing to azure blob storage delimited text and here we can select the link service and we can browse the path where we want to keep the file. So we want to keep the file under the testing folder click on continue. First row as header so we can keep that and click on ok. So these two copy data activity will be going to copy the data into the csv table first and second copy the file to the testing folder. The next thing that we need to delete the file which is available at the source. So we have to use the delete activity and need to connect with the copy data one as well as with the copy data two. So once these two activities will be completed then delete activity will be executed. So in the delete activity simply we want to delete the file which is available at the input folder so in the logging setting we don't want to enable the logging. So this is the process that we have to follow let me try to execute and verify. So here the copy data activity one will be executed so data will be inserted into the csv table copy data two will be executed so file will be copied from input folder to archive folder that is the testing one. So here we have to wait until this will not be executed. So as we can see copy data one and two both are executed with success. So go to the SQL server and here let me try to refresh the table. So here we will see the data as we can see similarly we can go inside the testing folder. So inside the testing folder we will see the file that we can see customer details dot csv file now here we can go inside the input folder so we should not see the customer details dot csv file. So that is gone from here. So if we want to move the file then we have to follow this process. So thank you so much for watching this video see you in the next video.