SSIS – Error: “metadata could not be determined because procedure uses temp table”

When you have a stored procedure that utilizes a temp table, SSIS may not be able to render the column set in a Data Flow Task because of that.

Here is a typical scenario:

To help resolve this, try using the EXECUTE statement with the WITH RESULT SETS option to define the result set:

Happy coding!