title: SSIS Execute SQL task with parameter
body: <p>I need to execute sql task based on parameter.
  Lets say if my @parameter = 1 then execute this sql if @parameter = 2 then execute this sql. I think of a work around but is there anything straight forward such as Len(?) or Len(@parameter1) ..</p>
  
  <p>Bottom line: I need to execute sql query based on what's passed to parameter.
  Let me know if that's possible.</p>