title: Can I use SQL on the output of a Merge Join?
body: <p>I'm using SSIS to fetch data from two Informix servers. I'm using a Merge Join object to combine the data together. Now, I need to summarize the data for reporting.</p>
  
  <p>I worked up the T-SQL for pivoting, counting and summing the data I want, but I don't know how to do that in SSIS. I just want to run a query against the output of the Merge Join. How do I do that?</p>
  
  <p>The pivot object looks too simplex for the job.</p>
  
  <p>Thanks! </p>