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