Need ssis expression

Question

Need ssis expression

komal145

SSCrazy Eights

Points: 9918
More actions
June 10, 2016 at 12:04 pm

#317114

Here is the agebucket column: 12-24
need lowerbound :12 and upperbound:24
Right now I wrote expression in tsql something like below:
Substring([AgeBucket],0,CharIndex('-', [AgeBucket])) As LowerBound
,LTRIM(REPLACE(Substring([AgeBucket],CharIndex('-', [AgeBucket]),3),'-','')) As UpperBound
How can we re-write as SSIS expression ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246979 More actions · Answer 1

komal145 (6/10/2016)
Here is the agebucket column: 12-24
need lowerbound :12 and upperbound:24
Right now I wrote expression in tsql something like below:
Substring([AgeBucket],0,CharIndex('-', [AgeBucket])) As LowerBound
,LTRIM(REPLACE(Substring([AgeBucket],CharIndex('-', [AgeBucket]),3),'-','')) As UpperBound
How can we re-write as SSIS expression ?

TOKEN( "12-24","-",1 )

TOKEN( "12-24","-",2 )

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

komal145 SSCrazy Eights Points: 9918 More actions · Answer 2

thing is agebucket column has "(other)" as value and "65+" this is not working:(

how to check if this values exists just palce this value in the column?

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

Use the conditional.

TOKEN( @[User::AgeBucket],"-",1) == @[User::AgeBucket] ? TOKEN( @[User::AgeBucket],"+",1) : TOKEN( @[User::AgeBucket],"-",1)

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Phil Parkin SSC Guru Points: 246979 More actions · Answer 4

komal145 (6/10/2016)
thing is agebucket column has "(other)" as value and "65+" this is not working:(
how to check if this values exists just palce this value in the column?

This is important information. Had you included it in your initial post, I would have provided a different answer.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel