I am trying to connect SSIS to an AWS RDS SQL Server instance. Whenever I try to run the packages through the SQL Server Agent, I encounter this error message:
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.
From what I can find online, the recommendation is to create a proxy account. This does not seem possible since I cannot create credentials in the AWS RDS instance.
Is what I am trying to do possible? If so, how do I configure the user/package to run correctly?