Hi, How do I do a conditional check for the left most character if it is an alpha or number in a Derived Column Transformation? Something like ISNUMERIC(newseq) ?"ABC" : "DEF" Thanks

There isn't an ISNUMERIC() function, but you could do something like the following: FINDSTRING("0123456789ABCDEF",UPPER(SUBSTRING(newseq,1,1)),1) > 0 ? "ABC" : "DEF" Just make the first parameter of the FINDSTRING be the complete set of characters you are searching for. You could also do comparisons, but then you would have to repeat the SUBSTRING() a number of times: (SUBSTRING(newseq,1,1) >= "0" && SUBSTRING(newseq,1,1) <= "9") || (UPPER(SUBSTRING(newseq,1,1)) >= "A" && UPPER(SUBSTRING(newseq,1,1)) <= "Z") ? "ABC" : "DEF"

Here are some other workarounds for the missing IsNumeric expression: http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com