Printing using SSIS

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  February 5, 2015 at 3:09 am

  #397977

  Can we autoprint a PDF from a network drive to a network printer using SSIS ?and I would like to schedule that SSIS package in a SQL job.

  Thanks

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  February 5, 2015 at 3:17 am

  #1775616

  If you can find the command-line syntax, you should be able to use an Execute Process task to do this.

  Here is a possible way of doing it.

  ---

• SQL.AP

  Hall of Fame

  Points: 3304

  More actions

  February 20, 2015 at 2:02 am

  #1778885

  You can do it using command line -

  AcroRd32.exe /t <file.pdf> <printer_name> <printer_driver> <printer_port>

  Eg: 2Printer.exe -s "C:\In\*.PDF" -prn "HP LasetJet 1100"

  Or, you can do it using Scrip Task in C# code.

  ____________________________________________________________

  AP