title: SSIS - Dataflow Destination Validation Before Insert
body: <p>I am using data flow to send data between different DB servers and I do not have a joined server.
  I need to validate the data with a stored procedure before insert the data from OLE DB source into the destination. May I know is there any way can achieve this?</p>