cancel
Showing results for 
Search instead for 
Did you mean: 

Workaround for ETL not running due to lack of Windows User privileges

Anon
Community Manager

Workaround for ETL not running due to lack of Windows User privileges

Windows User at times may lack the permission to run the SQL Service Integration Services. If there is a lacking then as a workaround:

1. Right-Click on SQL Server Agent > Jobs > BDI_UC_ETL and select Properties
2. Select Steps on the left hand side
3. Select the actual step
4. Select Run as "SQL Server Agent Service Account"

This is a temporary workaround, the permission where the Proxy account (which needs to run the ETL) needs to be given: The ability to execute SSIS packages

Regards

Jitesh
Tags (1)