Toad World® Forums

Can I use a stored procedure as the source for the Export Wizard Automation Activity


#1

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?


#2

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.


#3

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.


#4

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.