Hi Howard,

Thanks for the feedback, I just tried your and it works fine. I would like to do this through a data flow task for so that I can move the data to a staging table for further transformation. how do I go about getting that working?

Here's my current flow:

Using execute sql task, I populate the variable (vEnd_Date). quotes are also taken into account in this query as the value is return as a string.

once this is done this is where I want to use this variable in a query on my OLEDB source.

I tried using the sql task and set the resultset option to full result set but I get the error "[Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".