SSIS – Delay Validation
Very often we need to delay the schema validation when we don’t want the validation performed. There might be a couple of reasons. One, our password has been changed. Two, there are branches on our steps, and the validation will fail for sure.
In the case, we should set the DelayValidation property to True at both the Connection level and each data flow level.