The error message is a little hard to narrow down.
May I know the type of your connection manager?
Also you could try to set the property of the DelayValidation to true to see if it will help.
In addition, you may click the failed to see if it could give us more information.
If the answer is helpful, please click "Accept Answer" and upvote it.