title: How to add additional column to an output recordset from another data source in SSIS?
body: <p>I have a Data Flow in an SSIS Package that gets data from an SQL server using an OLE DB source (call it <em><code>source1</code></em>). I am saving that data to my final destination database with a OLE DB Destination. Our users have asked for a new requirement, between the source and final destination to pick up  a piece of data from another source database (call it <em><code>source2</code></em>)  based on a column value key picked up from <em><code>source1</code></em>. Then with the combined data of <em><code>source1</code></em> and <em><code>source2</code></em> save it to the destination place. Is there a way to do that in SSIS ? The only thing i can think of it to get all the possible data from source 2 and save it into a temp table in the destination and then link it up. I don't want to do this since this could be a lot of data!</p>