Connection String

[shiveshsingh]

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?

[avinashelite]

Try like this ..

With connection 1 import all the 5 tables required and then connect with connection 2 import rest of the tables ....

[Chanty4u]

Or else you can move all the tables into one server database and load from single server it will be good practice.