Using SSIS, without downloading how to read data from Excel file which is located onto URL

• Dinesh R. Nandwalkar

  SSC Enthusiast

  Points: 147

  More actions

  November 12, 2017 at 11:37 pm

  #402667

  Hello
  Source excel file is located onto URL, customer dont want to download file and SSIS package should read data from that file into SQL table.
  Is it possible? If yes then please guide

  Regards,
  Dinesh

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  November 13, 2017 at 1:58 am

  #1967716

  You cannot read data from a URL path for an Excel file, it is not possible.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• Dinesh R. Nandwalkar

  SSC Enthusiast

  Points: 147

  More actions

  November 13, 2017 at 11:03 pm

  #1967891

  Thanks Shawn