Hi SSIS Guru,
Our existing process used linked server to update, insert and delete data on destination. The script below runs as procedure on server to populate #temp table and uses Account table to join to update remote table. This #temp table populates about six thousand
rows every night.
What is the best option if I want to eliminate linked server? Should I create staging tables on remote server and copy both #temp and account tables to remote server?