title: SSIS 2008R2 Dynamically Change Web Reference URL for Different Environments
body: <p>I'm running MSSQL 2008 R2.</p>
  
  <p>I want to be able to dynamically change the Web Reference URL in a Script Task when the package is deployed in different environments without having to change it manually and build it again each time.</p>
  
  <p>I've got the Script Task to work with the Test Web Service,</p>
  
  <p>I've added the Wed Reference in the Script Task and set the URL behaviour to "Dynamic".</p>
  
  <p>I've got a Package Variable called "WebServiceURL".</p>
  
  <p>so what do I need to do now in the Script Task for it to use the "WebServiceURL" package variable when calling the Web Service.</p>
  
  <p>I know very little C# .Net.</p>
  
  <p>Thanks in advance.</p>