I was wondering if someone can help me.
I have a CVS file with a column name called 'Invoice #'. During importation I have renamed this column as 'invoicenumber' in the output column in the Flat File Source.
In Derived Column instead of the default NULL values for empty strings for this column that occurs in a SQL Server table I want to replace these with 'No Invoice Number'
I've put the below expression in the Derived Column:
ISNULL(invoicenumber) ? "No Invoice Number" : "invoicenumber"
However, the final table is still showing NULL for these empty strings.
I've also tried REPLACE function and this does not work.