Scenario:There is a emp table and from that table insert  the data to targt where sal<3000 and reject other rows.

Following are the steps for achieving it

  1. connect out-puts from SQF to Update Strategy transformation.
  2. In properties of  Update Strategy write the condition like this
  3. Connectthe Update Strategy to target

If  you have any better way to solve this, don't forget to comment

  1.