I sometimes have trouble remembering the details of the individual default roles in SSIS 2008. These can be found in the msdb database of SQL Server 2008, and are summarised in this table, which will hopefully help a bit:
SSIS 2008 msdb Role Name |
View All Packages |
Export |
Execute All Packages |
Execute All in SQL Agent |
Write Features |
db_ssisadmin |
Yes |
Yes |
Yes |
Yes |
Delete/Change all packages Import Packages |
db_ssisoperator |
Yes |
Yes |
Yes |
Yes |
None |
db_ssisltduser |
Own packages only |
Own packages only |
Own Packages only |
Delete/change own packages Import packages |
The Windows Admin role can see the execution progress of packages that are currently executing, and can also stop these packages. However, note that the package execution will stop at the point of the next task, so the package execution abort activity may not occur immediately. To add this post to Twitter, please click here.