January 5, 2016 at 8:30 am
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
January 5, 2016 at 8:36 am
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
January 5, 2016 at 9:23 am
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
January 5, 2016 at 9:33 am
I don't think you can assign the condition(s) to a variable like you're trying to do.
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]
January 5, 2016 at 9:43 am
Please suggest the way by which I can get the solution
January 5, 2016 at 10:29 am
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"
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply