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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply