I am trying to convert a salary field (coming from a comma delimited txt file) into an int so that I can compare it to 20000 in a SSIS conditional split condition.
What I do in the conditional split is this:
Cast([Salary] as int) > cast(20000 as int)
However, I keep getting this error in the attatchment. How can i convert my text field Salary to an int and then compare to 20K?