I figured it out just like metioned earlier. Take a look at this link http://lukehayler.com/2010/03/setting-the-sql-command-property-using-expressions-in-ssis-2005/

The trick is that even though you are using the data reader data flow transformation, you...