When using loadspec.exe to load a data list spec that contains a reference to a temporary table, users receive the error: Unable to validate the schema of procedure [stored procedure name]. Invalid object name '#TEMP'.
There are two possible solutions to this issue: 1. Create stored procedure manually in SQL Server 2. Create a second stored procedure spec with code and load separately