Store Procedure Result to Text file using SSIS package

[grsvenki]

Here i am new in Developing the SSIS package

I need your support to come up with the solution.

I have 10 different set of stored procedures which I have to export into text file, all 10 procedures will return the same set of columns (only calling parameters are different).

I am not getting the solution how to do ?

Could you please help me to understand how to export the data from a stored procedure output to tab delimited text file?

Please let me know how to build the ssis package ?

Thanks

[Rabbit]

In a data flow task, use the merge task to combine the results of multiple inputs.