Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose i have 2 data sources.
In 1 data source, i have 5 tables and in other i have 3 tables.
I wrote 1 connection string and took 3 tables from first source. Then wrote 2nd connection string and took 3 tables.
Now i need remaining 2 tables from first data source.
Do i need to write first connection string again?
Try like this ..
With connection 1 import all the 5 tables required and then connect with connection 2 import rest of the tables ....
Or else you can move all the tables into one server database and load from single server it will be good practice.