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
Princess
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
Tab alleman
source
to share