A usually request that see often is how to create a dynamic parametized query inside a data reader source. Normally required to connect to Sybase, AS400 or others through ODBC connection.
Because this is a tip follow the sequence of the images below. If you have some doubts, let me know.
Step 1. Create ADO.Net connection
Step 2. Add a data reader to a dataflow and configure it as the images below
Step 3. Goto expression property of the dataflow and add the expression (customize it to your case)
"select * from Sales where Yr= " + @[User::uvYearSales]
I hope this tip can help you!
Regards,
Pedro