Getting an IMAGE from SQL and convert to PDF using SSIS

• Brad Allison

  Hall of Fame

  Points: 3550

  More actions

  January 19, 2017 at 6:46 am

  #320692

  I successfully created a ran an SSIS job that pulls out a unique filename and an image related to that filename and saves it into a shared location.  However, simply putting a .pdf extension does NOT create a pdf file.  Is there a way to do this maybe using FILESTREAM in some vb or c# code?  Or is there really not a way to do this without using maybe a full version of Adobe to convert them?

  Thanks for the information

  UPDATE:  After doing almost a full day of research scouring the internet I have come to the conclusion that there is no way to natively extract data from an IMAGE field and save it to a pdf file.  I have now done this two ways - through SSIS export column, and through writing some VB code.  I also CAST IMAGE as varbinary(max).  The files are written to the directory specified and because I attach a ".pdf" extension, they look like pdf files, but Acrobat will not open them.  They will, however, open with an image reader, or paint.  I did download a free pdf convertor and it works but I was hoping not to have to do this.