need help in ssis package
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
November 17th, 2010 5:28am
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/
November 17th, 2010 5:33am
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..
November 17th, 2010 7:39am