Download file from url in script

• vmon

  SSChasing Mays

  Points: 624

  More actions

  September 10, 2009 at 12:24 pm

  #204514

  Is there a way for me to download a file from a url in a stored procedure? I am trying to download the following files in a script to my local PC. Any suggestions?

  http://setas-www.larc.nasa.gov/HubbleImages/humes1.jpg

  http://setas-www.larc.nasa.gov/HubbleImages/humes2.jpg

  http://setas-www.larc.nasa.gov/HubbleImages/humes3.jpg

  Thanks.

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  September 10, 2009 at 12:26 pm

  #1051880

  1. Acquire an executable called WGET or equivalent..

  2. Using xp_cmdshell execute a command using WGET to get the file.

  There is no internal support for this.

  CEWII