Post reply

Directing flow to different files depending on values in one of the columns

  • October 26, 2018 at 7:46 am

    #380346

    The attached SQL is executed by the OLEDB Source of the Data Flow.
    The 16 returned records need to be split by the condition on the AvgInStock table.
    If AvgInStock  <  40 then direct all such rows to File1.txt
    If AvgInStock >= 40 then direct all such rows to File2.txt

    What is my most preferred way to do it in BIDS 2008 ?

    Likes to play Chess

  • October 26, 2018 at 7:54 am

    #2011343

    VoldemarG - Friday, October 26, 2018 7:46 AM

    The attached SQL is executed by the OLEDB Source of the Data Flow.
    The 16 returned records need to be split by the condition on the AvgInStock table.
    If AvgInStock  <  40 then direct all such rows to File1.txt
    If AvgInStock >= 40 then direct all such rows to File2.txt

    What is my most preferred way to do it in BIDS 2008 ?

    Use a Conditional Split.

    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