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?