Clever Geek Handbook

Compare 2 guides in conditional separator in SSIS

I am creating a conditional split in SSIS to figure out if a row is new or updated. One of the columns I want to compare is guid and it allows null.

I tried to compare the column like COLUMN! = Destination_COLUMN. However I am not allowed to compare contours. Thoughts on workarounds as there are many directions in the DB.

thank

+1


source to share


1 answer


Use the derived column transform to create string versions of your GUIDs, and compare string columns instead of GUID columns.



+1


source






More articles:


All Articles