I am trying to pass a date paramater into a query of a DataReader
Source, not an OLE DB database. I cannot get it to work, or actually
know where to start.

I am trying do something simple like this..

select * from table where datefield = MYDATEVARIABLE

Is it possible to pass variables to a DataReader? Any documentation or
help would be appreciated! Thanks.

Hello billg51 (AT) yahoo (DOT) com,

The property that needs changing is the SqlCommand property of the DR Source.
Look at your Data Flow task in the control flow part of your package. This
exposes that property from the pipeline through to the control flow. Because
of this you can now use Expressions to build the SqlCommand property.


Allan