I think your best choice is probably a script task. This link might help.

http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.html