The documentation states that a temp table must be the target of a dynamic execute into, but there is nothing preventing that. There is also the assumption that the insert must supply all columns and is positional - but that generally only makes sense if the temp table has not yet been defined. If it already exists, then one could expect that the insert would happen based upon matching the column names - but it does not. That needs to be clear in the code/docs.