Query to get the seeing from the RunQA table:
Tags » SQL Query
SQL Server Linked Servers feature allows you to query data from other databases (even non SQL Server databases) from within SQL Server.
While I believe large data transfer jobs are best handled using an ETL solution like SSIS, sometimes all you want is a just a couple hundred rows of data from another database and setting up an ETL jobs might be overkill. 357 more words
Creating ETL Stored Procedures: 14 more words
Working with ETL Objects
It has long been a best practice to build software using multiple layers of abstraction. By creating an abstraction layer, the underlying objects are always used indirectly. 220 more words