I want a stored proc which results multiple result set and i ant to put the resultset in different sheet of an excel file.
i googled and got info of writing a script component which results in multiple result set but how do i map to different sheets of an excel
http://www.codeproject.com/Articles/32151/How-to-Use-a-Multi-Result-Set-Stored-Procedure-in
or Is there any other way to do it?? by using for loop container?? Please help.