March 25, 2013 at 11:59 am
Hello everyone.
I have a requirement where I need to get the output resultant set of various stored procedures and
get them out into a single text file.
I currently used a data flow task with the stored procedure as the source and a text file as the destination.
I would like to know
1) how I can do the same for the remaining stored procedures, sending the results out and appending to
the same text file.
2) I would also like to know how I can include the column headers in the text file as currently I do not have
the column headers included in the output text file.
March 25, 2013 at 12:02 pm
Are the output columns always the same, or do they vary by proc?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 25, 2013 at 12:04 pm
Hi Phil,
The output columns are actually different.
They vary by proc.
Thank you !
March 25, 2013 at 12:13 pm
Love & Peace (3/25/2013)
Hi Phil,The output columns are actually different.
They vary by proc.
Thank you !
But you want them all in the same file - presumably, then, with new column headings intermingled with the data at the point where one proc's data finishes and another's starts?
There is no nice way of doing this. Personally, I'd set up five dataflows which write to five separate text files and then have an Execute Process task at the end which does a copy/append of the five text files to a single, new, file.
I don't have SSIS in front of me and cannot remember the answer to your question about column headings - hopefully someone else will chime in.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 26, 2013 at 7:08 am
Hi Phil,
Thank you for giving me direction.
I figured out the answer for the second part of the question.
March 26, 2013 at 7:12 am
Love & Peace (3/26/2013)
Hi Phil,Thank you for giving me direction.
I figured out the answer for the second part of the question.
Excellent - so everything developed, tested and implemented now? 🙂
Or do you have any further questions?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply