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