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

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  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.

  ---