April 7, 2009 at 1:09 am
Just want to know what the minimum privileges required for me to run SSIS package through the scheduler. Does it have to have local admin rights?
April 8, 2009 at 1:09 pm
As a general guideline, the account that runs the package as a job step must have all the same permissions as an account that runs the package directly, in order to access any external resources that the package needs to access.
If the package is stored in the MSDB database, and you've set the protection level to Rely on server storage and roles for access control, the Database roles now control read and write access to the package.
You need to assign one of the Integration Services fixed database-level roles or assign a user-defined database-level role, to the Reader role of the package. The fixed database-level roles in SQL Server 2008 are db_ssisadmin, db_ssisoperator, and db_ssisltduser.
If you assign a fixed database-level role to the package, the user account that calls the package from the job step must be a member of that role. If you assign a user-defined role to the package, the user account must be a member of one of the fixed database-level roles and a member of the user-defined role.
April 8, 2009 at 5:54 pm
Thanks! Will try this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply