SSIS permission error

I am getting the following error

Executed as user: NAM\SqlAdmin001. Microsoft (R) SQL Server Execute Package Utility Version 11.0.3381.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:55:37 AM Failed to execute IS server package because of error 0x80131904. Server: MATLKTBATSQD001,14330, Package path: \SSISDB\Flex4Cast\F4C\tmp_F4C_ETL.dtsx, Environment reference Id: 2. Description: The EXECUTE permission was denied on the object 'xp_regread', database 'mssqlsystemresource', schema 'sys'. Source: .Net SqlClient Data Provider Started: 10:55:37 AM Finished: 10:55:37 AM Elapsed: 0.125 seconds. The package execution failed. The step failed.

I searched in the web and found that hot fix from the Microsoft

http://support.microsoft.com/kb/2720171

however my server  sql  version is sql server 2012 sp1 CU6

I tried in many ways but could not find any solution

Could you please provide me the workaround for this
chandradineshbabuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<Potentially stupid answer, since no one else has responded>
You'll want to eyeball what user will run the SSIS package, and manually attempt to execute xp_regread, to see if it's GRANTed to that user.  

It's pretty typical of a DBA to deny such privs.
0
chandradineshbabuAuthor Commented:
The user has SA rights.

the issue has been resolved as i provided following
Grant Xp_regard to public role
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
So ... did my comment help?  'Excellent thought' implies that it did.
0
chandradineshbabuAuthor Commented:
Excellent thought
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.