I need to replace and cast the data in a data set column and would like to do this using the Derived Column Transformation. I know how to do it with multiple derived column and a data conversion task how I believe it should be possible with a single derived column task.
The challange is that the columns contain the following DT_STR values:
- No Value
and I would like to replace these with a simple boolean to safe space in my DB
I know I need to do something like this:
(DT_BOOL) REPLACE(beta, "No Value", "")
However that doesn't cover the No/Yes conversion to boolean.