Click here to Skip to main content
15,936,677 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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.
Updated 8-Dec-22 3:04am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900