Using Stored A Procedure with Temp Tables for SSIS Packages

Some stored procedures are complex and so require temporary tables or table variables. This FAQ tells you how you can do it.