To avoid encountering the SSIS-965 error, follow these best practices:

Use a simple Script Task to regex-clean the data before it hits your main transformations.

Don't let a single row of "dirty" data break your warehouse. By implementing better error handling and logging early in your package design, you can turn a catastrophic SSIS-965 failure into a minor, logged event that doesn't stop your production schedule.