The job is to extract the photos from the SQL table into .jpg format.
I have created an SSIS package and used an Export column to extract the photos. I used a derived column to give the extention as .jpg
Apparently , even though the photos are being extracted with an extension of .jpg , its actually not .jpg but .bmp.
Any idea how we extract the photos in valid .jpg format ?