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.
| Author |
Topic |
|
dbaman
Starting Member
46 Posts |
 Posted - 2009-07-31 : 11:22:10
|
| I have SQLServer 20005 .One of my Developer is needed to create some SSIS packages. What all permission do I need to grant so Developer can create SSIS Package?Do I need to give Developer the role sqladmin ?R |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-08-03 : 06:57:47
|
| Not sure I understand. You don't need any specific rights to create an ssis package. In the package, you will be reading data from tables and writing data to some other tables, so you need read/write rights on the respective databases. To schedule a package using sql agent is a different story. Hope that helps. |
 |
|
|
|
|
|
Permission to Create and Run SSIS?