Anyone using SSIS to pull data from Oracle is well aware of the issues
associated with parameterized queries. I say issues, there really is only
one - you can't create a parameterized query....

Anyway, I'm wondering if this is an SSIS limitation, or if any product using
OLE DB as it's connectivity solution would have the same issue because it's
an OLE DB problem?

What is the usual work around for this? I suppose you could wirte a script to
create a huge where clause generated by values from a lookup source, but
that's not very elegant and is there a size limit issue? How have others been
solving this issue?

"TheMadTexan" wrote:

I define a package variable called mySQL and within a VB Script I set it to
the SQL I wanted.

"TheMadTexan" wrote: