I have a task (Derived Column Task) and I want to write something like this : IsNumeric(aColumnOfString) == true ? "All numbers" : "there are some characters" Here aColumnOfString can be something like "123a5" or 12345". I do not want to simply check if the left-most character is a number or not. I want to check the entire expression and return me a TRUE or false. A TRUE is returned ifthe entireexpression contains ONLY numbers, and FALSE otherwise. I read some posting using regular expression. But that is not a solution for this situation. Anyone knows how to accomplish this, please help!

Steve, To determine if astring contains only numbers, you could use the data conversion transformation to convert the string to numeric. the strings that convert okay are all numbers. set theerror to redirect rows.the error data stream would be the strings that contain characters. Frank

Hi, try this... ********************************************************************************************************************* Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) Try Row.COLUMN = CStr(CType(Row.COLUMN, Int64)) Catch Row.COLUMN = Row.COLUMN End Try End Sub End Class ********************************************************************************************************************* You write this code in a script component and select the COLUMN as an input column with readwrite enabled properties. I hope it helps. Regards, Oscar.

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