Thanks Lowell and Scott for the reply.

Please help me with following queries:

1. Where and how can we access and check the temp table .

2. Why is Linked servers required.

3. And can we load a same table with data coming from 2 different data sources connected through ODBC.

If the scenario is non descriptive than do let me know what additional information is required.

Thanks in advance