Every once in awhile our ETL jobs in SSIS fail. The error message looks like this:
Login failed for user 'TEAMASP\SQLAdmin'. Reason: Failed to open the explicitly specified database '$Project::BICfg_Svr'
As you can see, I have a parm at the project level. But SSIS is not pulling in the parm value, and instead is literally trying to connect to a database named what my parm name is?