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,
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 5:33am

you can use Lookup task and oledb datasource task to join two tables. Following is the sample In the above sample, you can remove derived column and union all..
November 17th, 2010 7:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics