Hello,

While trying to save package into SQL server, I'm getting the error:

The SaveToSQLServer method has encountered OLE DB error code 0x80040E14
(Access to Integration Services package 'Test2' is denied.). The SQL
statement that was issued has failed.
(Microsoft Visual Studio)

It seems to be permissions issue, but all my attempts fixing it failed.
Even, tried give user dbo on msdb db -- didn't help

Does anybody have an idea of how to grant permissions in SSIS?

Thanks,
Gary

Gary,
I'm sure you found resolution on this. I'm currently having the same
issue. Would you mind sharing how you resolved this?

Thanks.
Donna


*** Sent via Developersdex http://www.developersdex.com ***

please grant the user also the role sqladmin or if the user is an windows authenticated add him to the admin goup...

- Alex

From http://www.developmentnow.com/g/103_...-is-denied.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

I got the same error message when I tried to remove a saved to server package. I am a sysadmin on that server. After looking at the sysdtspackages90 table in the msdb database, I was able to fix the problem.

The problem in my case is for some reason there were entries of readrolesid and writerrolesid for the package. I set both to NULL and then the problem went away.

From http://www.developmentnow.com/g/103_...-is-denied.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com