Ssis-835 Jun 2026

SSIS-835 Error Report Error Description: The SSIS-835 error is a common issue encountered in SQL Server Integration Services (SSIS) that typically occurs when there is a mismatch or inconsistency in the version of the SQL Server client library used to connect to a data source. Error Message: "The EXECUTE permission was denied on the object 'sp_describe_unhandled_exception', database 'msdb', schema 'sys'. (Microsoft OLE DB Provider for SQL Server)". Causes:

Version Incompatibility: Using an incompatible version of the SQL Server client library to connect to a SQL Server instance. Insufficient Permissions: The account executing the SSIS package lacks necessary permissions on the msdb database.

Troubleshooting Steps: Step 1: Verify SQL Server Client Library Version

Check the client library version used in your SSIS package. Ensure it matches or is compatible with the SQL Server instance version. SSIS-835

Step 2: Check and Grant Necessary Permissions

Connect to SQL Server Management Studio (SSMS): Use an account with administrative privileges. Grant Permissions: Execute the following T-SQL script in the msdb database.

USE msdb; GO

GRANT EXECUTE ON OBJECT::sys.sp_describe_unhandled_exception TO [YourUsername]; GO

Replace [YourUsername] with the actual username or service account used by your SSIS package. Step 3: Validate and Adjust SSIS Package

Open SSIS Package: Use SQL Server Data Tools (SSDT) to open and edit your SSIS package. Connection Managers: Verify that all OLE DB connections use the correct and compatible provider (e.g., "SQLNCLI11" for SQL Server Native Client 11.0). SSIS-835 Error Report Error Description: The SSIS-835 error

Step 4: Test SSIS Package Execution

Execute Package: Run your SSIS package from SSDT or SQL Server Agent to verify that the SSIS-835 error is resolved.