title: Check numeric in DerivedColumn Data Flow Task in SSIS
body: <p>Is there any way where I can check if the field is numeric in derived column/Conditional Split of the data Flow task in Sql Server Integration Services 2005.</p>
  
  <p>Functionality should be like ISNUMERIC() function.</p>
  
  <p>Currently I'm using </p>
  
  <p><code>((DT_NUMERIC,12,0)fieldname= (DT_NUMERIC,12,0)fieldname)</code> </p>
  
  <p>in the derived column expression to check if the field name is Numeric. But if the field name contains characters like 123ABC instead of numeral 123, the above expression throws an exception because of conversion failure and package execution stops. </p>
  
  <p>If we had a function like ISNUMERIC(), than the we need not do all this circus. Does anybody know if there is any function like this to check if the field is numeric or not in SSIS. </p>