My project is to collect different server database collect information to a database, through setting up the JOB, SSIS in SSIS through OLE DB Connection in the Expression of dynamic connections, cooperate the For loop, in the execution of dynamic Connection error, please look at the great god, thank you!
Attribute DelayVaildation has been changed to True
Error message:
[the Execute SQL Task] Error: Failed to acquire the connection "dongtai". The connection may not be configured correctly or you may not have the right permissions on this connection.