Having SSIS package, the flow is Data moves from Hadoop to SQL and from SQL to Postgres. Placed it in GitLab for CI CD. Made the dtsx automate by creating a job in SSIS. When running manually the job got succeeded. In automation the job is failing as Hadoop has no permission from SQL server. Please suggest how to do.
What I have tried:
In job, step Run as :SQL Agent Service Account, once with SSIS Service Account.