Export the Image from database using SSIS

We have the database table where Images are stored from the different API applications. We get the requirement that we need to export this image and store it in the folder.

For Exporting the Image from the table we are using the Export Column Transformation.

In this Demo, we will see how to Export the image from the table.

We have table Product where we have stored the Image.  

We need to export this image on the below location.  

Now we are taking the Data Flow Task.  

Taking Source as OLEDB Source and doing the configuration.  

Now taking the derived column to create the dynamic Image path.  

Now we are taking the Export Column transformation.

                                     

Double click on this transformation.  

Click ok.

Now the package is ready to run.

Before run see the source file. 

Running the package.

Package executed successfully.  

Now see the destination folder.  

Thanks