title: SSIS - best way to integrate business rules?
body: <p>What is the best way to separate business rules in data transformations from data loading/extracting in SSIS? </p>
  
  <p>Is there a known pattern in SSIS that supports this design? (without external technology, like custom tasks using c#).</p>
  
  <p>From what I've experienced, the 2 are done simultaneously with derived columns, conditional splits and the like. </p>
  
  <p>Thanks for sharing. </p>