To resolve the SSIS-835 error, follow these steps:
| Layer | What’s Happening | |-------|------------------| | | The Microsoft Access Database Engine (ACE) ships as two separate binaries: 32‑bit ( ACEODBC.dll / ACE*.dll ) and 64‑bit . They are not side‑by‑side; installing the 32‑bit version overwrites the 64‑bit one and vice‑versa. | | SSIS Runtime | SSIS packages can run 32‑bit or 64‑bit . The default on modern servers is 64‑bit . The runtime loads the exact version of the provider that matches its own process architecture. | | Package Design | If you built the package on a dev machine using the 32‑bit ACE driver (common when you install only the Access Database Engine Redistributable), the package metadata stores the ProgID Microsoft.ACE.OLEDB.12.0 . When the package is executed on a 64‑bit SSIS server without the 64‑bit driver , the provider cannot be instantiated → SSIS‑835 . | | Azure‑SSISIR | The Integration Runtime container is 64‑bit only; you cannot switch it to 32‑bit. Therefore, any ACE‑based component must use the 64‑bit driver, or you must refactor the data flow. | | Security Context | Even when the driver exists, the account running the SSIS job may lack read/write permissions on the underlying file (Excel, Access). The provider then returns a generic 0x80004005 unspecified error , which surfaces as SSIS‑835. | SSIS-835
In the SSIS source code the ACE provider error path was given the internal identifier 835 when the product team logged it. It never became a public “error number” like DTS_E_OLEDBERROR (0xC0202009), but the community started referring to the whole symptom as SSIS‑835 . The moniker stuck. To resolve the SSIS-835 error, follow these steps:
To troubleshoot an issue like this, here are some general steps you can follow: The default on modern servers is 64‑bit
Unlike typical releases where the final scene is purely mechanical, SSIS-835 ends on a melancholic, ambiguous note. The aftermath focuses on the cost of the encounter, leaving the viewer with lingering questions about the characters’ future. It’s haunting and memorable.