RE: SSIS - Exec Stored Procedure with Temp tables

[allyne]

Hello,

I have a stored procedure that uses a few temp tables. I have created an SSIS package that executes this stored procedure and exports the end results to a .txt file. The problem I'm having is that I'm not seeing any fields or tables when executing the SSIS package. If I create a sql table to store the results it works fine. Any suggestions as to why it won't work without creating an actual table?

Thanks for your help!