SSIS - Condition to split string value

  • In SSIS, how to write condition to split string value to different destination ? Example if type='Item' then go db a else db b. Thanks

    **Please delete the post as I already found the answer

  • sqlbaby2 (4/2/2016)


    In SSIS, how to write condition to split string value to different destination ? Example if type='Item' then go db a else db b. Thanks

    **Please delete the post as I already found the answer

    ..And for the benefit of others, the way to do this is to use the Conditional Split component, inside a data flow.

    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

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

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