I have a package that logs using Configure SSIS Logs: Logging
It logs to a database (log)
I've set up a new connection to the DB and called this log
I've created a config file and added log to this:
<Configuration ConfiguredType="Property" Path="\Package.Connections[log].Properties[InitialCatalog]" ValueType="String">
So, if I create a job that runs the package and uses the config file, all works well and it logs
Now, if I change the name of the connection to logdb (for example), the job still works but it does not log
NOTE: I also amend the connection string to something that is wrong as this seems to take presedence over the config file
If I look at job history, it shows an error:
Log provider "SSIS log provider for SQL Server" Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "logdb" failed with error code 0xC0202009 ...
Why does the job still succeed?
Ideally, in this situation, I want the job to fail as it cannot acquire a connection and cannot log