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.

    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 2 posts - 1 through 1 (of 1 total)

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