Dynamically changing the value in Conditional split

Question

Dynamically changing the value in Conditional split

vipin_jha123

Hall of Fame

Points: 3085
More actions
January 5, 2016 at 8:30 am

#310651

Hi All,
I have source flat file , I want to exclude the records containing below state.
I have created one variable which data type is string and value is as given below
State == "AA" || State == "AE" || State == "AP" || State == "AS" || State == "FM" || State == "GU" || State == "MH" || State == "MP" || State == "PR" || State == "PW" || State == "VI" || State == "00" || State == "99"
In Conditional split when I am using that variable I am getting error as below screen shot.
Kindly help me to achieve my requirement

Viewing 6 posts - 1 through 6 (of 6 total)

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

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

vipin_jha123 (1/5/2016)
Hi All,
I have source flat file , I want to exclude the records containing below state.
I have created one variable which data type is string and value is as given below
State == "AA" || State == "AE" || State == "AP" || State == "AS" || State == "FM" || State == "GU" || State == "MH" || State == "MP" || State == "PR" || State == "PW" || State == "VI" || State == "00" || State == "99"
In Conditional split when I am using that variable I am getting error as below screen shot.
Kindly help me to achieve my requirement

Cannot see any screen shot.

vipin_jha123 Hall of Fame Points: 3085 More actions · Answer 2

Sorry for that

Hope you understand the issue.

I want to pass the filtr value in conditional split by variable so that in future if I want to add some more filter I can add it without touching the code

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

I don't think you can assign the condition(s) to a variable like you're trying to do.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

vipin_jha123 Hall of Fame Points: 3085 More actions · Answer 4

Please suggest the way by which I can get the solution

Phil Parkin SSC Guru Points: 247180 More actions · Answer 5

vipin_jha123 (1/5/2016)
Please suggest the way by which I can get the solution

You could try using FINDSTRING() instead.

FINDSTRING(@[$Package::StateExcludeNames], [State], 1) == 0

where [State] is the data column and

$Package::StateExcludeNames is a string parameter (easily configurable from SSISDB)

= "AA,AE,AP,AS,FM,GU,MH,MP,PR,PW,VI,00,99"