I've been searching and trying a bit, but i can't seem to find a way to use database from two database of different server to insert the data into a table. Since i'm writting with [Database].[Schema].[Table], i'm getting error that the table does not exist, which is normal when i look at the SQL code generated.
So is there a way to get data from multiple Servers?
t<DB>ELT components are some what related to Extract-Load-Transform (ELT) method and they are used inside a database.