Combining results from different data sources

• Jerry44

  Mr or Mrs. 500

  Points: 537

  More actions

  April 13, 2009 at 9:56 am

  #202060

  I have two data elements and element is coming from a different OLEDB datasource. One is the numerator and the other is the denominator the result is to be stored in another database.

  What would be the best way to handle this. The most intuitive way would be to combine the two into a derived input but that only accepts one input.

  Thanks.

• vishal.gamji

  SSCertifiable

  Points: 6126

  More actions

  April 13, 2009 at 10:24 am

  #976720

  Did u try using merge transformations?