Allow someone else to run SSIS package without sa right

This post was formerly published at my beloved old blog "On the quest of a DBA's adventure......"

How to enable developers to develop their SSIS package without giving them the SA right? You need to be a part of db_ssisdbadmin role in MSDB database. Provide the db_ssisdbadmin role to the user or group and that’s almost all you need. (folder permission to the C:\Program Files\Microsoft SQL Server\100\DTS\Packages or they will have trouble to deploy the package into that folder)

MSDB > Security > Role > Database Roles > DB_ssisadmin

After adding windows account to this role, either you can use SSIS installation wizard or DTUTIL to deploy the packages.