Can someone tell me what are the security watchouts there are in running SSIS or the SQL Server Agent I am having trouble running a job on a package that runs fine through Integration Services. The only difference seems to be that SQL Server Agent is running the job on the schedule.
Does SQL Server Agent need to have certain rights
Do I need to be part of a certain group besides Admin
Does the package need to have a particular security for someone to run the job
I was finally able to get the package set but now I can't schedule the thing to work.
Security Requirements for running SSIS
Sarath25177
hi,
You might have to add the user to the following roles in MSDB database (minimal access) to successfully schedule and run a SSIS package
For SQL Agent - 'SQLAgentOperatorRole', 'SQLAgentReaderRole', 'SQLAgentUserRole'
For executing SSIS package - 'db_dtsoperator'
If you are using any bulkinsert operations - you might have to add the user to 'bulkadmin' role in SQL Server.
Thanks,
Loonysan
http://mystutter.blogspot.com