New to SSIS and trying to set up a new set of ETLs. We have a Database server and a ETL server.
I use a proxy account on the DB server to call the ETLs. It does this via powershell.
If i run the package locally via the proxy account it runs with no errors. If i run it from the DB server Agent job it fails with the error:
Executed as user: DOMAIN\SSIS_Proxy. The job script encountered the following errors. These errors did not stop the script: Unhandled Exception: System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object args) at System.String.Format(IFormatProvider provider, String format, Object args) at Microsoft.SqlServer.Management.PowerShell.Res.GetString(String key, Object arg0) at Microsoft.SqlServer.Management.PowerShell.SqlPowerShell.GetErrorRecordMessage(ErrorRecord errorRecord) at Microsoft.SqlServer.Management.PowerShell.SqlPowerShell.HandleAgentJob(RunspaceConfiguration config) at Microsoft.SqlServer.Management.PowerShell.SqlPowerShell.Main(String args). Process Exit Code -532459699. The step failed.
If i run the agent job via a proxy with my account it works! so it must be security related?
The proxy account has the following sec which i thought was enough, as i said it works when i run it locally on the same account.. Could anyone help? clean it up for me?
DCOM permissions based on this article:
Launch and Activation Permissions - Local and Remote
(I tried with just remote permissions and i couldnt get packages to run)
ETL DB engine:
User to MSDB with db_ssisoperator
Thanks for any help!