Well,

In my case the query worked perfectly fine, both in SQL 2000 and 2005, also, the headings reflected the name correctly.

So I don't know,

Does that mean something is wrong...

I think you might be right, that this is a SSIS issue of not binding it correctly, or maybe i might not be setting something correctly, not sure yet. Even...

Hi Ian

have you tried creating 2 DateTime variables 'StartDate' and 'EndDate'

then using them as 4 Input Date parameters in the Parameter Mapping section of the Execute SQL Task Editor :

User::StartDate  ...