SSIS running on its own server under account 'ourserviceaccount'.
We then have SQL Agent running on a separate server under the same account.
I have set up a job that calls an SSIS package, which in turn calls a number of child packages. However, I get this error...
Error 0xC0202009 while preparing to load the package. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x%1!8.8X!.
The job is run as the same service account credentials.
In the parent package that calls the child packages, I have set the connection manager to Windows Authentication.
What step am I missing?