SSIS how to setup security for devleopment team

Last Post 11 Jul 2007 04:53 AM by mcdye. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mcdye
New Member
New Member

--
11 Jul 2007 04:53 AM
I am hoping there is a way to setup a secure method for the development to deploy their packages to msdb. I have granted the Domain\DevGroup rights to msdb in the db_dtsltduser role. They are trying to connect to SSIS on the server to import package. Which they are getting Access Denied. I have looked at BOL but only getting more confused.

How do I setup security so they can store their packages in SQL?
How do you actually take the devolped package and push it to SQL?

TIA...
You are not authorized to post a reply.

Acceptable Use Policy