Converting word document to PDF via SSIS?

• Jobs90312

  Mr or Mrs. 500

  Points: 533

  More actions

  October 18, 2022 at 11:59 am

  #4100908

  Hi all,

  In my SSIS project I have a variable which consists some string data. My goal is to convert this lines of data to a pdf file.

  What would be the best way to achieve this?

  I have created a File System Task which will create a word document with name like "Log_File_2022_10_18.docx".

  Now how do I transfer the contents of this variable to this word file and convert this file to pdf format from SSIS package?

   

  Thanks

  • This topic was modified 2 years, 2 months ago by  Jobs90312.

• Phil Parkin

  SSC Guru

  Points: 246988

  More actions

  October 18, 2022 at 2:55 pm

  #4100998

  There is no support in SSIS for creating PDFs.

  However, if you can work out how to create PDFs using .NET assemblies, you may be able to do this by using a script task. See link.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel