The data type of a source changed from varchar(255) to varchar(max). In my SSIS package, a derived column is failing because "SUBSTRING does not support the data type DT_TEXT".
This doesn't make sense. Why does it now think that the field is DT_TEXT? What is the best way to get around this, Convert, Cast?
My derived columns is using this field with SUBSTRING to create a new field called CodeNew, with data type DT_STR, length 7.
The fields MinCode and MaxCode are the two fields with the new data type varchar(max).
(DT_STR,7,1252)(ISNULL(qInd) ? "Unknown" : SUBSTRING(MinCode,1,4) == "MISC" ? SUBSTRING(MinCode,5,4) : SUBSTRING(MinCode,5,3) + SUBSTRING(MaxCode,5,2))