January 30, 2009 at 1:44 am
Hi All,
When running SSIS job i get below error ?
"The job failed. The Job was invoked by User sa. "
According to this we need to create proxy account devlogin and using that job executor account we need to create SSIS.
Can any one please help me in telling where in Business inteligence we need to specify the job executor . i am not able to find the option
or is there any way to schedule SSIS package?
January 30, 2009 at 7:48 am
There is another way. Assign the following access privileges to the user\owner running the job
msdb --> Security --> Roles --> Database Roles --> db_dtsoperator
create a role and assign your users to that role and add this role the above dtsoperator database roles.
or you could read into this for more details:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply