I am seeing the same issue. I have seen some posts regarding removing the loopback query, but with the way cross-server queries operate, it is often optimal to use loopback....

This is an issue I have also run across in SQL 2005. It works fine using BCP from SQL 2000 but BCP from 2005 seems to handle the temporary table...