Thursday, 22 May 2014

Convert decimal to string in derived column in ssis

ISNULL(ContractItemNumber) ? "NOT_PRESENT" : (DT_WSTR,50)ContractItemNumber


You can use the above expression to convert a column namely "ContractItemNumber" from decimal to string


No comments:

Post a Comment