 Hello friends, welcome to SSUnitech. So, see this side and this is continuation of SSIS tutorial. So, today we gonna discuss about export column transformation. Before going forward, if you haven't to watch last video, so I would strongly recommend to watch that video. So, let's start with export column. So, export column transformation reads DT text, DT end text and DT image. Data from database and write it a file with the name and path given in the another column of the same row. And in this transformation, it can be used to override or append existing file. So, as we can see, here we have OLEDB source, then we have export column transformation. There is no need to use any destination. So, data will be loaded automatically while we are going to use export column transformation. So, let's have a look of SQL Server table. So, here we have import column table and we have imported data in this table in our last video. So, as we can see, we have only two columns in this table. First contain the information of file path. Second is the file name. So, in file path where we want to export this file and this is our actual file. So, I want to execute this selected statement. Then we can see we have total four files. First is our image file. Second is our excel file. Then media file. Then again image file. So, we have two image file and one media and one excel file. So, go to one SSGT to implement the package. Here we need to create one more package. So, new SSIS package. Then I am going to rename this package with export column. Then we have to use dataflow task. So, we can drag and drop this dataflow task and then double click on this dataflow task. Here we need to configure our source and transformation. So, our source is OLEDB source because we have data in our SQL Server table. Now we need to double click on this OLEDB source. Then we need to select the connection manager. So, click on new. We have already made the connection. So, I am going to use that one. Click on OK. Here we need to select the table. So, here we have import column table. So, we can select import column table and then go to own columns. So, we want all these columns now click on OK. Then we need to configure our export column transformation. That is our label inside this other transformations. So, we can drag and drop this export column transformation. Then we need to connect with source. Now we need to double click on this export column transformation. So, here we can see extract column. So, here we need to select that column which contains the actual file. So, this is files. Then where we want to export this file? So, we can select the file path. So, here we have option for allow append, force truncate. These are the options available. So, we don't want to use that one. Then click on OK. So, we have then our export column transformation. So, as we can see in this folder we don't have any file. We have only one file which is file path. Once we execute this package then files should be loaded in this folder. So, we can click on start. So, as we can see four files have been loaded successfully. Now we can stop this package. So, now we can check the size of Excel file. It's 9 kb. Now go to one export column and this time I want to select this checkbox allow append. Now click on OK. Then I want to execute this package one more time. So, click on start. Now we can see Excel file size has been increased. Other file size as well. Now we can stop this package. So, I hope you have understand how we can use export column transformation. Thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. And don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.