If you make the call in the Stored Proc that created the temp table, the object is still around until the proc terminates. Usually try to do some clean up...
Greetings.. No BCP is very limited going out. You can do a bulk insert, but can't really export from transact SQL. To get around this I've used the following.