Create a Service account to run SSIS packages on SQL server 2008 Agent Services
Posted on 2012-09-13
I've created a Service account to run the SSIS packages under SQL server Agent, But it did not work, as the jobs failed with the following error message.
"Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 1). The step failed. "
and one things, I've SSIS package that I've setup source connection manager on a remote server on the same domain to get the source data into my data warehouse tables.
What is the parmissions SQL server Service account should have in order to run the SSIS package without any failure.
Thanks in Advance.