I could do, but I would prefer not to have to create yet another table. SSIS is supposed to be this flashy ETL tool, surely it must be able to...

yip i've tried a case statement, it did feel a little silly because I was trying to set something to 0 or 1 when it was already that. SSIS knows...

thanks for everyones help, here is what I was looking for. http://www.sqlnerd.com/ssis_dynamic_dates.htm

bitbucket,

Thank you for the SQL for just todays date. I am more looking for a step-by-step process of how to include this date in the file name everyday. So what...

Hi Chris,

Thanks for the quick the response, I chose your example without the variables, changed the table name and hey presto..!!

Works a treat, exactly what I was after.

Thank you.

maui