sql server - Check numeric in DerivedColumn Data Flow Task in SSIS -

Is there a way where I can check that the field is in numeric column / in the conditional partition of the data in the SLL function < / P>

Currently I am using

((DT_NUMERIC, 12.0)) field name = (DT_NUMERIC, 12,0) field name)

In the derived column expression for the test, if the field name is numeric, but if the field name contains 123 ABC characters like 123 , Then the above expression throws exception due to conversion failure and package execution.

If we had a function like ISGLEERIC (), then we need not do all this circus. Does anyone know that if in such a way, to check whether the field is numeric or not in SSIS

We use the following technology:

1. Property form for the derived column component, 'Configure error' button to bring error output configuration Can be marked.

3. Configure error and pseudo-actions to "ignore failure" for this column (or any other column)

4. < P> Now, if the conversion of this column fails for one line, then the package will continue to execute. The column value will be set to zero for that row. You can use the latter component to check the empty values, and take appropriate action.