Here's my scenario: I'm working with an SSIS 2008 data flow task. I have 3 oledb connections set up in the connection manager; one to SQL Server 2005, one to DB2 and one to Oracle. I'd like to join data from all 3 of those connections and insert the results into a SQL Server 2008 table. Represented very simply in sql, the select part might look something like: select a.field1, b.field2, c.field3 from oracle a, db2 b, sql05 c where a.index = b.index and a.index = c.index The merge join looks like it can handle inputs from two oledb sources, but how might one go about merging data from more that two external data sources (in one operation, if possible)? I don't have a lot of experience with SSIS and the hours I've spent searching the web on this topic haven't yielded any clear solutions. Thanks! John

First join two sources, then join the result to the third. And add an order by in your source queries so you don't have to sort in SSIS (that's slow). See point 5 of the best practices.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Hello, Do something like this 1--Take two source, SQL and ORACLE , then use the Merg Join and join the data. 2--Use the output of Merge Join +DB2 to Second Merg Join. You have to use Two merg join transformation, in first you can join any of the two and then in second output of first merg + your another source ... thanksAamir