I've created a few SSIS packages with one package being the main package to call my other packages
With each package I set-up package configuration to use a SQL Server table
This connection will need to use a SQL Server Authentication, and not windows authentication.
I've then imported all my packages into SQL Server.
When I run the main package I go to connection manager and supply the password to the connection string for the Configuration DB
But when the child packages execute, that all throw errors saying the login failed for the SQL Server user account.
This is because the password is not saved.
I have even changed the connection string within the configuration table for this DB, but it still fails
How do I pass the connection string to the child package to access the configuration DB?