SSIS 2008 Add Web Reference

• mr_clements

  Grasshopper

  Points: 17

  More actions

  October 7, 2015 at 4:34 am

  #303925

  I am desperately trying to add a web reference to a script task in SSIS (BIDS 2008). I go into the script task, right click on the top node in project explorer, choose 'Add Web Reference' and then enter the following url: 'http://www.webservicex.net/globalweather.asmx' . What I get back is the following error message: 'Operation is not valid due to the current state of the object.'

  It is important to note that my company uses a proxy server and I believe this may be what is causing the issue as I also had the same problem using Visual Studio 2010, however I managed to resolve this by adding the following to devenv.exe.config:

  <defaultProxy useDefaultCredentials="true" enabled="true">

  <proxy usesystemdefault="True" proxyaddress="http://[proxy ip]:[proxy port]" />

  </defaultProxy>

  I did the same for BIDS 2008 yet it did not fix the issue.

  Any help on this is much appreciated.

  Graham.