January 29, 2014 at 9:30 am
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
January 29, 2014 at 9:51 am
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]))
January 29, 2014 at 10:04 am
Thank you!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy