Permissions required to view Data Sources for an SSIS Package in a Job Step

• rackerland

  Old Hand

  Points: 359

  More actions

  July 1, 2013 at 5:32 pm

  #279791

  Version: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4276.0 (X64)

  I have SSIS Packages that execute via a SQL Server Job. I want to grant members of the SQLAgentOperatorRole fixed database role the ability to view the "Data sources" tab (read-only) in the Job Step Properties. For some reason, the Connection Manager options are blank while other Tabs such as "General", "Set Values" and "Command Line" all show their respective values as read-only already. (I attached a screen print of the Tab in the Job Step I'm referring to.) I haven't found anything short of assigning sysadmin privileges (which obviously I don't want to do) to expose the values in the Data Sources Tab to the SQLAgentOperatorRole.

  Can someone please tell me what permissions are required to allow a read-only view to the Data Sources Tab?

  Thanks for the help!