How to EXEC a stored procedure from SSIS to get its output to text file.

SQLServerCentral » Latest topics

How to EXEC a stored procedure from SSIS to get its output to text file.

Hello, I wrote a stored procedure that reads records into a temp table and then creates a pivoted output from the data in the temp table. 

Here is my code:

[code language="sql"]
ALTER PRO

more info...