title: SSIS: How do I pass string parameter in an update statement in Execute SQL Task?
body: <p>I have one execute SQL Task in SSIS 2012 which has update statement. I want to pass a string variable in the where clause of this update statement. The update section is as below:</p>
  
  <blockquote>
    <p>where coalesce(s1.iteration, '') not like '%?%' and s2.Iteration = '?'</p>
  </blockquote>
  
  <p>Here, ? needs to be replaced with a string variable, which in this case would be <em>08152017</em>. I have added the variable to the Parameter Mapping. Screenshot is attached.</p>
  
  <p>The task executes successfully but does not updates the value in the intended column. It seems the query is not passing the value.What am I doing wrong? How do I check that the SQL inside the Execute SQL Task is actually getting the value from the variable?</p>