HTTP command

• ionas

  Mr or Mrs. 500

  Points: 551

  More actions

  January 8, 2018 at 8:45 am

  #325293

  Hi All,

  I need to run an http from an SQL procedure (for example http://woodwell.gr/uploads/resources/26755/e-00018411-normal.jpg) AND save the return jpg file to a local folder.

• Thom A

  SSC Guru

  Points: 99141

  More actions

  January 8, 2018 at 8:51 am

  #1974911

  Why with a SQL SP? Would you consider using SSIS instead?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• ZZartin

  SSC-Dedicated

  Points: 30921

  More actions

  January 8, 2018 at 9:22 am

  #1974916

  Well if you have xp_cmdshell turned on downloading a file is straight forward as a powershell command.