Error Message: Exception from HRESULT: 0x80070005 Access Denied
This problem is occurring while executing the SSIS package in SQL job using file system package source method. There are multiple reason may have possibilities for this issue that listed as below.
Insufficient Privilege to User
The user may have limited permission to execute the SSIS package and read the configuration file from the drive. We need to check the user has enough permission to read data from the drive. If else, grant folder permission to user access the specified path from the drive.
Mismatched Assembly Reference
If the SSIS project has script task and the task may have assembly reference which is varying the path based on the SQL Server version. We need the ensure the assembly reference path on deployed server.
- We might be developed 32 bit server and deploying the package on 64 bit server.
- We developed and deployed the SSIS package on lower SQL version and the production server version may differ from development version.
Mismatched Deployment Target Version
Sometimes the problem is occurring due to mismatched target version. We might have developed lower version of SQL Server Data Tool (SSDT) and the SQL server will not allow to execute the package in run time. We can change the deployment version as below steps.
Step 1: Open the SSIS Project in Visual Studio.
Step 2: Go to Solution Explorer and right click on the project and choose the Properties.
Step 3: Select the Configuration Properties and choose the SQL server version from the drop down list in Target Server Version.
Step 4: Build the Solution and replace the package file on file system package source.
No comments:
Post a Comment