SQL Server Agent Jobs to Run SSIS Package -

SQL Server Agent Jobs to Run SSIS Package -

i have ssis bundle tried schedule job in sql server agent.

in order accomplish have created credentials user having sysadmin role server. have created proxy business relationship run job principals added sqlserveragent,sqlserveroperator,sqlserverreader.

while configuring job selected bundle source file scheme , given bundle path execute same.

package running , updating results table stand lone not working when executing via sql job.

error: process not created step 1 of job 0x7d722f8836388b46956b164e33de8955 (reason: required privilege not held client). step failed.,00:00:00,0,0,,,,0

fix tried: modified bundle security encryptallwithpassword , no luck still.

check sql server agent service business relationship create sure has permissions database , folder packages beingness called from.

the proxy business relationship user bundle run as, create sure selected in job step.

for bundle encryption, unless saving credentials in package, can set protection level "dontsavesensitive". sounds proxy business relationship have permissions need assigned.

sql ssis