hi all, Can anyone help me to join two different databases and tables to import data to destination one database. Anyone help me to query to join two tables from two different databases.praveen

I suggest you to read : Connection Manager, Data flow task, Oledb Data Source, MERGE Join Transformation and OldDb Destionation. Rahul Kumar, MCTS, India, http://sqlserversolutions.blogspot.com/

you can use Lookup task and oledb datasource task to join two tables. Following is the sample http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part1_p1.aspx In the above sample, you can remove derived column and union all..