saving sp results

Hi all

I have a heavy sp which i need to run out of hours.

The sp will be run a number of times but with different parameters, i can do this as a job but i need the results of each time it is run saved to a different file (.csv)

Please help!!!

Rich

Hi Rich.

I think DTS would be the best tool to do it. You can run you procedure with different parameters as separate steps of the DTS package, then dinamically generating Name of your output file using Dynamic properties of DTS. Your package can be scheduled to run outside of working hours and can be design to inform you if any unexpected problems.

NB.

|||

NB

I have just tried that and it works find, thanks for the advice

Rich