In SSIS Control Flow, I a have an Execute SQL Task that populates a result set with data.
How can I make that same data accessible to my data flow - so that I can export the data to a flat file?
Thank you
You will have to use a data flow after your Execute SQL Task to the best of my knowledge. In the data flow, you will have to use a data source to get the data I think.
Maybe some of the gurus here know of another way.
No comments:
Post a Comment