September 20, 2011 at 3:48 am
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
September 20, 2011 at 3:52 am
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
September 21, 2011 at 7:33 pm
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