Is there a way I can use a wild card expression for a derived column in SSIS? I want to create a derived column which would output, for each row, either "A" or "B" depending on whether the amount in another column is a negative figure or a positive figure. So the wildcard I'm searching for is '%-%'
The column I want to perform the expression on is a float type.
Or maybe this is not the right approach?