• thank you for the response steve, but i won't be able to do join since the tables are in different servers. sorry should ve mentioned it. i have edited my post. and it must be done in SSIS.