separate numericstring values in ssis

• asranantha

  SSCarpal Tunnel

  Points: 4246

  More actions

  February 20, 2013 at 10:10 pm

  #274391

  Hi friends i have small doubt in ssis package .how to solve issue

  flat file source data contains like

  id , name

  1243abcde, ravi

  15896655djk , hari

  9dhajkvekjkddk,kali

  011galidvadidevi,lalai

  based on this source data . i want load id columns data to load only numerics data in destinationat table

  output like

  id , name

  1234 ,ravi

  15896655 ,hari

  9 ,kali

  011 ,lalai

  i have an idea useing derived columns transformatoin write expresion substring and findstring.

  but i cannot write exactely expression.plese tell me the condition expression.in ssis package

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  February 21, 2013 at 8:37 am

  #1590003

  I think your best choice is probably a script task. This link might help.

  http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.html