I am trying to export the results of a store procedure to an excel file.
The store procedure is made up of about 30 select statements that return mostly count or sum values e.g.
select count(blah) from table_blah where blah = 'blah blah'
I am a novice at DTS and it only passes the first result from the first select statement - how do I get all the results?
Cheers - and thanks for solving this headache!