Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSIS Packages very urgent

Author  Topic 

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-04-17 : 11:47:15
HI Gurus,

What permissions one sholud have to cretae and execute SSIS packages.



Thanks,
ServerTeam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-17 : 12:44:29
There are 3 role for SSIS in MSDB database:
1)db_dtsoperator :weakest role. can only execute and schedule package
2)db_dtsltduser :create packages
3)db_dtsadmin: manage package and have read/write operation
Go to Top of Page
   

- Advertisement -