I have a stored procedure that produces the output that I would like to export to an Excel file. I have not been able to get TDP to accept a stored procedure as the source object. What approach should I take to get the data from the SP for the Export Wizard automation step?
It works in SQLSERVER to get the data from the SP for Export Wizard automation step. which database you use? and post your Export Wizard script to me to investigate.
I am using SQL Server. What I want to do is execute the stored procedure, capture the result and store it into a TIC table. Attached are a couple of images showing the SP and the log.
We do not support capture the stored procedure result and store it into a TIC table. You can try to use function instead of “stored procedure” in “Execute” activity to store data into TIC.