Validation in SSIS

Here-in, we will do row by row validation using script component. You may write your own logic for validation, and after validation move faulty data to separate destination . Pretty straight forward

[@treydugas806]

This is very helpful thank you!

[@animals4191]

Very much helpful
Thanks

[@rahulkumbhar6406]

good info