What privileges are required to store an SSIS package in SQL Server 2008

Question

Hi,

I want create SSIS package as a DB User.

Also I want to store it to SQL Server not in file system. The DB user only have a db_owner privilege on a particular database.

What least privileges are required to create SSIS.

Already I have assigned the following

grant execute on dbo.sp_ssis_checkexists to test grant execute on dbo.sp_ssis_putpackage to test

please provide feedback.

thanks

Answer 1

Please add the user to following roles in msdb database,

db_dtsadmin db_dtsltduser db_dtsoperator

Hope it works.

Thanks, -Mohsin