Derived Column Syntax Help

• John215

  SSC Eights!

  Points: 871

  More actions

  January 29, 2014 at 9:30 am

  #396187

  I need syntax help with with the expressions of two columns (SSIS 2008). I have a variable called @[User::Test]

  that outputs CAT.DOG, MOUSE.MOOSE, etc. etc

  I need the first column to grab everything BEFORE the "." and

  the second column to grab everything AFTER the "."

  Example:

  Column 1: CAT.DOG becomes CAT

  Column 2: CAT.DOG becomes DOG

• KS

  Hall of Fame

  Points: 3326

  More actions

  January 29, 2014 at 9:51 am

  #1684385

  Something like this...

  Col1 : SUBSTRING(@[User::Test],1,FINDSTRING(@[User::Test],".",1) -1)

  Col2 : SUBSTRING(@[User::Test],FINDSTRING(@[User::Test],".",1) +1,LEN(@[User::Test]))

• John215

  SSC Eights!

  Points: 871

  More actions

  January 29, 2014 at 10:04 am

  #1684399

  Thank you!