SQLTeam.com | Weblogs | Forums

Need SSIS Expression


I have an string like "A10" or ""AB12". I need to exclude the alphabets and just need to send the numeric value to target table. How can I write an expression for this kind of strings in SSIS. Could some help me out.


SSIS has access to all the of the wonders of C# so you can use a regular expression depending on how you are moving the data around such as via a script or transformation.

Regex.Replace(s, "[^0-9.]", "")

This post has great information on how to accomplish that using expressions.



Thanks James