HTTP Connection in SSIS 'Unable to connect to the remote server'

• Ells

  SSCrazy Eights

  Points: 9901

  More actions

  November 19, 2009 at 2:15 am

  #140045

  HTTP Connection in SSIS 'Unable to connect to the remote server'

  I have a HTTP connection in my package. This is the first time we have needed to get a spreadheet from the internet. I have put a test Server URL in there of http://www.konesans.com/downloads/Sample.txt

  I have used Internet Explorer to get to the site and all is well. When I test the connection from the connection manager it fails with the message 'Unable to connect to the remote server'

  Has anyone suffered the same? I am guessing some sort of corporate firewall may be the reason I can not acces the site from SSIS. Is there a best practice for this sort of thing?

  Cheers

  Ells.

• glenn brown

  Old Hand

  Points: 301

  More actions

  January 12, 2016 at 12:11 am

  #1851243

  Happen to sort this? I'm getting this exact problem.....

• Ells

  SSCrazy Eights

  Points: 9901

  More actions

  January 12, 2016 at 12:19 am

  #1851244

  Sorry,

  that was 9 years ago I have forgotten so much of what happened back then 😀

  However yes, it probably is that you are unable to connect due to some corporate firewall etc. Ports etc

  Mark

• glenn brown

  Old Hand

  Points: 301

  More actions

  January 12, 2016 at 5:15 am

  #1851268

  Ha, no probs. I'll respond back in 7 years with my findings...