Compare two databases

• ringovski

  Hall of Fame

  Points: 3521

  More actions

  September 20, 2011 at 3:48 am

  #244025

  Hi All,

  I need to compare a two columns from different databases,

  DB SSAT: column:ID VARCHAR

  DB SNAP: column CODE VARCHAR.

  I have setup two datasources with these DB's and written a basic select for each that pulls the data from the column.

  Select ID

  FROM SSAT

  Select CODE

  FROM SNAP

  I am trying to put the results in a variable for comprasion, but not sure how to do this or if there is a better way. I ried using merge function but couldn't get it to work.

  What is the best way to compare them and ask if they are the same?

  Thanks

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  September 20, 2011 at 3:52 am

  #1383690

  use a lookup transfomation to check if the columns match and then use the match and no-match data flow connections to handle the matched and non-match data

• ringovski

  Hall of Fame

  Points: 3521

  More actions

  September 21, 2011 at 7:33 pm

  #1384910

  steveb. (9/20/2011)

  ---

  use a lookup transfomation to check if the columns match and then use the match and no-match data flow connections to handle the matched and non-match data

  Sweet thats it perfect thanks.