Ssis-927
– confirmed the job was using the Agent service account.
SSIS‑927 is not an SSIS‑specific error code; it is a that bubbles up to SSIS when the package attempts to connect to a database for which the current Windows or SQL login lacks the necessary permissions. SSIS-927