Using conditional split in SCD Type 1 change
Posted on 2013-01-15
I am trying to implement SCD T ype1 change using lookup and conditional split in SSIS
I am using lookup and conditional split in my SSIS package to spilt data between
match and non matched rows.
Non matched rows are inserted into the target table as new rows , while the matched rows are passed through conditional split to check if the source fields is different from target field and if it finds such an entry it updates the target files value with the source value.
source.column != lookup.column
while the above expression does not check for null values in the columns, i use the below expression to handle it if fields are of integer data type
(isnull(source.column_name) ? 0:source.column_name)) != (isnull(lookup.column_name) ? 0 :lookup.column_name)
for non integer columns(eg:datetime,varchar,text)
i use data conversion to change the datatype to string and then with conditional split i use the below expression to check nulls and unmatched values for the fields
(isnull(source.column_name) ? "" : source.column_name)) != (isnull(lookup.column_name) ? "" :lookup.column_name)
However i am not able to check null values with fields having ntext datat type
I tried converting the datatype to DT Wstr but it does not wrk
Please advise. how to check for null values in the columns with ntext data type