title: How to pass Variable to script task SSIS, Visual Studio 2010, c#
body: <p>I'm trying to find the way how I can pass the server name as a variable to script task within SSIS solution. I'm using VS 2010 and c#. </p>
  
  <p>Within my SSIS I have Name (string) variable defined and I added this variable as ReadOnlyVariable within my Script task. </p>
  
  <p>c# code looks like this: </p>
  
  <p><a href="https://i.stack.imgur.com/taEAA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/taEAA.png" alt="enter image description here"></a></p>
  
  <p>Problem starts (I guess) when I'm trying to pass the local ServerName to the OleDbDataAdapter which works perfectly with strConn, but doesn't work with my ServerName variable. </p>
  
  <p>I have tried to pass it in a form "User::Name" but it didn't work. </p>
  
  <p>Any suggestion would be appreciated :) </p>
  
  <p>Best</p>