Using database on seperate servers with tELTMSSqlInput

Five Stars

Using database on seperate servers with tELTMSSqlInput

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?

Moderator

Re: Using database on seperate servers with tELTMSSqlInput

Hello,

t<DB>ELT components are some what related to Extract-Load-Transform (ELT) method and they are used inside a database.


Best regards
Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.