Forgive me if I'm not understanding your issue correctly, I'm new to this lark! I acheived something similar recently I think:

I passed a series of values generated via a SQL task as a result set to a variable with a datatype 'object'. I then used a foreach Loop container (Foreach ADO Enumerator) with a dataflow which queried an Oracle Database. Each value in the resultset variable was passed to a second variable (datatype string) via the loop. This in turn was passed as a parameter in the dataflow and rows inserted into (in this instance) an excel destination.

I used the Microsoft OLE DB\Microsoft OLE DB Provider for Oracle to connect to the oracle database in the dataflow using the SQL command from variable access mode and a third variable to store the query as an expression. The format of the Query Variable I used is as follows:

"SELECT column1, column2

FROM Table1

WHERE (Column3 = '" + @[User::SecondVariable] +"')"

All works nicely as I am just using it to match data that exists in a sql database with data from the oracle database and the volume is small.

Anyway - hope it helps, if not - ah well!:-)