Hi, we are migrating to SQL Server 2012 using the SQL Server Native Client 11.0. We have found we can no longer use the BCP api with a local temporary table as the call to bcp_init it fails with:
"SQL Diag:42000:1:11525:[Microsoft][SQL Server Native Client 11.0][SQL Server] The metadata could not be determined because statement 'select * from #Test' uses a temp table.\n"
We are using BCP to insert data into ~40 tables asynchronously. We use the local temporary table to remove duplicates from the source data, then merge into the database tables to ignore any duplicates in the destination table. Using real tables would be difficult to manage in this scenerio.