Hi Team, I have a stored procedure which produces Mutiple result sets as output. Now by using Execute SQL Task I have execute the SP and stored the output in a variable with a type of Object. Now I need to send the multiple result sets to Excel destination. can some one please help me on how to achive this

There is some code here that may help: http://consultingblogs.emc.com/jamiethomson/archive/2006/01/04/2540.aspx http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me