Validate Numeric or Non-Numeric Data in SQL Server Integration Services without the Script Task

(Ghanesh Prasad) In SQL Server Integration Services we don’t have an ISNUMERIC() equivalent function within the SSIS expression language. If you know C# or VB, you can code a script task to check if data is numeric or non-numeric, but if you don’t know how to code in C# or VB you might be in trouble

Read More - Register for Free Membership