The SQL Agent is running the package as 'FNBN\OTGDEV04$'

This is a local server id which I will assume does not have access to the instance you are trying to connect to. Try configuring SQL Agent to run with an id with the proper authority. Or you can grant 'FNBN\OTGDEV04$' the authority on each instance.