 మ్లవి పాల్చాంట్చి పిదిస్ంటి విలియాయె. మాలింటాడిమాళాయని. ధాలీన౦ిచిాని. ప్చిచ్చినజణ. లిటిథే. పింటోంటోపి. పాట్చిటాలిలిసి. � So, we want to load that files in our SQL Server database or any other database. So we have to use import column transformation next is the data type for the output columns must be DT text DT n text or DT MS. So before going forward, I would like to tell you about what is the prerequisite. So we should have any source file like flag file that would contain the information of file path. As we can see these are the files. So this is our excel file. This is our flat file and this is our media file and these are the MS files. So we want to load these files in our SQL Server database. So here we have a flat file that is contained the information of our file path. So once we open this file, then we can see this is our MS file. This is our excel file and this is our media file and this is our again MS file. So it has contained the information of file path. So go to on SSMS to check the table. So this is our table import column table. So it has only two columns. First is file path and second is file. As we can see the data type of file path is where care. So it would contain the information of file path and in our files it would contain the actual file and data type for this we have where boundary. So this is our package in our flat file we have contain the information of file path and then we need to use import column transformation and then already we destination where we want to load the data. So go to on SSDT and here we need to add one more package. So right click on this SSIS package then new SSIS package. Then I want to rename this package with import column. So this is our import column. Then inside this control flow we have to use data flow task. So we need to drag and drop this data flow task. Then double click on this data flow task. So here we need to configure our source transformation and destination. Our source is flat file. So we have to drag and drop this flat file source. Now double click on this flat file source. So here we need to make the connection as we don't have any connection manager right now. So click on new. Then it would ask for file name. So we can browse. Then we can select our file path file. Click on open. Then we make sure that this check box will not be checked. As we have seen we don't have any column name in our flat file. So as we can see we don't have any column name. Go to on columns. So as we can see we are getting this data. Now go to on advance. Then here we can change the width. So I gonna change this by 100. Now click on OK. Then go to on columns. So we want this column. Now click on OK. So we have done our source. Now we need to configure our import column transformation. So we can drag and drop this import column transformation. Then we need to correct the source. Now double click on this import column transformation. So as we can see we have input columns tab. So go to on input columns tab. Then we need to select that column. That is contain the information of file path. So this is our column zero. Now go to on input output properties. So this is our input column properties. And this is for output column properties. So go to on input. Now we can expand. As we can see we have input column. Now we need to expand our output column. As we can see we don't have any output column right now. Then we need to add output column. So add this column. And we can rename this column by files. So it would contain actual file. So here we need to take care one thing. Here we have linux id. So linux id 24 in my case. When you will be practicing. Then it might be different. So go to on input column. And here we can see we have an option for file data column id. Here we need to update that linux id. That is 24. So that has been updated successfully. Now click on OK. We have done our import column transformation. So now we need to configure our destination. That is OLEDB destination. So we can drag and drop this OLEDB destination. Connect with import column transformation. And now double click on this OLEDB destination. So here we need to select the connection manager. So click on new. As we have already made the connection. So click on OK. Now we need to select the table where we want to load the data. So we want to load the data in import column table. So we can select. Then go to on mapping. So as we can see files has been maxed successfully because input column name and destination column name is same. And we need to map file part manually. So we need to click on OK. So we have done this package. Before run this package go to on SSMS and execute our selected statement. As we can see initially we don't have any data in this table. Now we need to execute our package. So click on start. So as we can see four rows should be inserted in our table. So we can execute our selected statement. Then we can see this is our file path and this is our actual file and it has in binary format. So this is our image file. This is our Excel file. This is our media file and this is again our image file. So 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.