Compare two databases

  • 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

  • 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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply