Thursday, September 20, 2012 10:00 PMwe want to allow developers to view job settings. I have granted
this works to a degree but they cannot see datasource connection settings for SSIS packages. Does anyone know of a way to give them this without granting sysadmin?
Friday, September 21, 2012 2:42 AMModerator
You could use SQL Server Business Intelligence Development Studio to see datasource connection settings for SSIS packages. Click connection manager and select property, you could see the connection settings.
Integration Services Roles (SSIS Service): http://msdn.microsoft.com/en-us/library/ms141053.aspx.
If you still have any problem, please post the thread in SSIS Forum for quicker and better support.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.