Hi Sean,

thanks for reply, please let me know what further information is required...

I have a select statement that I need to run 15 times with a different where clause and the output to be excel.

SSIS will ideal going forward, for now I need to cater for the previous 18 months. Rather than running 15 select statements for 18 months = 270 statements I trying to find a quick to run these statements and save me a lot of time...

Thanks