You see performance degradation as the engine struggles to process the problematic row in memory Microsoft Tech Community .
:
Example:
No impact on downstream reporting or secondary SSAS cubes . SSIS-965
SSIS is designed to solve complex business problems by managing data movement and transformation. Common use cases include: You see performance degradation as the engine struggles