Here’s my problem:
Two database servers – I gather the id’s I need in one database – run queries against those ids in the other database.
Take the results and write it to the first database and export it to excel.
My problem is ETL does not like temp tables and my company does not allow linked servers or queries between servers.
I cannot get ETL to like the temp table even with the Delay Verification and the Retain Connection.