'SSIS Dynamic Connection Manager to multiple server
I have a SSIS package that connects to multiple servers. Some servers are SQL Authentication and some are Windows Authentication. I have a table that stores server details and a flag that identify whether the server is Window or SQL authentication.
Is there any way we can dynamically connects to multiple servers based on authentications in SSIS ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|