**Hi experts, We are unable to add config file in the job step for ssis execution. When ever we click on add button we are getting below error. We have added user to SSIS Package Execution proxy. Please suggest me how to get ride of this.
Failed to retrieve data for this request.(micorsoft.sqlserver.management.sdk.sfc) Additional Information: An exception occured while executing a Transact-SQL statement or batch. The execute permission was denied on the object 'xp_availablemedia',database' 'mssqlsystemresource,schema 'sys'. The user does not have permission to perform this action. Thse statemetn has been terminated.(Microsoft SQL Server, Error: 229)
It appears you login does not have enought permissions.
see this link: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93737
answered Mar 09, 2012 at 09:07 PM