Hi, I am setting up a derived column to combine a variable that is entered to a previous derived column with a dataflow value.
(DT_I4)@[User::Actual_FileName] in this example = 1000 and becomes the derive column called TMC_Ident
Branch Key = '072'
(DT_STR,4,1252)TMC_Ident + (DT_STR,6,1252)Branch_key should therefore = 1000072 but is coming out from this expression as 100072 i.e. removing the leading 0 from the value.
Any ideas on how to avoid this?
Should I change (DT_I4)@[User::Actual_FileName] to be (DT_STR,4,1252)User::Actual_FileName] ?