onesegun
asked on
SSIS: Using wild search in derived column
Hi All,
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?
Thanks,
OS
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?
Thanks,
OS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for slapping me on the head