title: Create SSIS- SQL Task Oracle SQL Statement With WHERE Clause "IN" keyword
body: <p>I really hope I can get some input on this. I'm trying to create an SSIS package with SQL Statement with &quot;IN&quot; in WHERE clause (ex: SELECT * FROM Oracle.Table1 WHERE Col1 IN (?) ).  Basically, an Oracle SQL Statement with values from a SQL Server table.  I've searched and can't find anything.  Any suggestion will be greatly appreciated:</p>
  <ol>
  <li>Can I use an &quot;IN&quot; keyword with values in object variable?</li>
  <li>I've seen methods where &quot;ForEach&quot; component is used.  Wouldn't this create a SELECT statement for each value? Potentially, thousands of records.</li>
  </ol>
  <p>I've tried the following:</p>
  <ol>
  <li><p>Used SQL Command with statement: SELECT * FROM Oracle.Table1 WHERE Col1 IN (?) - where ? is an object variable (resultset 1 col from a SQL Server statement)
  When I try to select &quot;parameter&quot;, I get an error message.</p>
  </li>
  <li><p>Used SQL Command from Variable with an expression in a variable: &quot;SELECT * FROM Oracle.Table1 WHERE Col1 IN (&quot; + @[User::Obj_values] + &quot;)&quot;</p>
  </li>
  </ol>
  <p>FYI: I only have read permission to the Oracle DB :(</p>