I have store procedure, which has four output results and i am executing this SP which gives four output results.Now I want to export this resultsets into four CSV file. Can any one help me to achive these four CSV files form a single SP by using SSIS? i have to do this by using SSIS package only.

Is it returning multiple resultsets? Then it is not possible because you cannot consume more than one resultset returned (in the resultset mapping use Full Resultset and then you map it to an object variable, but it can only accept one resultset). Thus, I suggest you revise your design.Arthur My Blog

Anshu, ArthurZ is right. However, if I understand your problem right, then you might want to make a change. Add, an additional parameter to the Stored Proc that you currently have and let this parameter determine which result set of the four will be returned. So for example Let us call the additional parameter @RS IF @RS=1 return the 1st result set, IF @RS=2 then second result set and so on. And now, for your case, you can have four dataflows and pass the data into four different Csvs, now that each SP call spits out a single result set. Please mark as answer if this answers your question. Please mark as helpful if you found this post was helpful.

Thank you. I try it. Thanks for responding.