It is probably due to a temp table that is created via SELECT * INTO [#YOUR_TEMP_TABLE]

You will need to explicitly create your #YOUR_TEMP_TABLE at the top of the script.