Hi Thom A.
This is a query that I am currently using and it does return accurate data for what I can tell so far, but the formatted output...

Regarding this post: "You need to describe the expected result set's DDL, so that SSIS knows how to deal with the output."

So in my case how that would...

Hello, thank you for your suggestion. I came to find this information on how to export the results of a stored procedure to an XML file: http://www.sql-server-performance.com/2013/export-to-xml-using-ssis/
I am following...

Hi Jason, I completely understand your point. I truly appreciate your help, it been life saving. I was given this task in the very last minute and there were no...

Do you think that using dynamic sql the only way this can be achieved? I like the first code example that you gave me. If that can be used as...

Hello Jason,

I am not sure if I completely follow what your comments regarding the parameters are, but let me give it a try.

The situation is that this stored...