Dynamic connection manager in SSIS package, Use DelayValidation = TRUE on pkg level.

Since the connection manager is using the expression to make it flexible, the dataflow will always show the error icon. The tip is to turn the DelayedValidation to TRUE on the package level. In this way, the validation package won’t kick in until the run time.