468,514 Members | 1,631 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,514 developers. It's quick & easy.

Store Procedure Result to Text file using SSIS package

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
Aug 21 '13 #1
1 4470
Rabbit
12,513 Expert Mod 8TB
In a data flow task, use the merge task to combine the results of multiple inputs.
Aug 21 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Simon Verona | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.