Post reply

Dynamically changing the value in Conditional split

  • 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

  • January 5, 2016 at 8:36 am

    #1849539

    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

    #1849572

    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

    #1849577

    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]

  • January 5, 2016 at 9:43 am

    #1849579

    Please suggest the way by which I can get the solution

  • January 5, 2016 at 10:29 am

    #1849597

    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