x

unable to add config file in ssis?

**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)

more ▼

asked Mar 09, 2012 at 06:50 PM in Default

Shyam prasad gravatar image

Shyam prasad
132 13 13 15

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It appears you login does not have enought permissions.

see this link: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93737

more ▼

answered Mar 09, 2012 at 09:07 PM

TheSmilingDBA gravatar image

TheSmilingDBA
91 1 1 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x943

asked: Mar 09, 2012 at 06:50 PM

Seen: 1350 times

Last Updated: Mar 09, 2012 at 09:07 PM