Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
corkyhawk
5 Posts |
 Posted - 2007-12-05 : 11:36:22
|
| I'm trying to get a SSIS package to run as a SQL Server Agent job. The package uses a config file. When I try to add the config file to the job under the Configurations tab. When I click on the 'Add' button, I get the following error:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)The EXECUTE permission was denied on the object 'xp_availablemedia', database 'mssqlsystemresource', schema 'sys'. The user does not have permission to perform this action. The statement has been terminated. (Microsoft SQL Server, Error:229)Any suggestions? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-05 : 22:44:57
|
| What kind of permission do you have on the server? |
 |
|
|
corkyhawk
5 Posts |
Posted - 2007-12-17 : 16:12:30
|
| It appears that I have to have sa permission to add the config file. It works fine if signed in as sa. I can't get it to work with anything less. |
|
|
|
|
|
|
SQL Server Agent with config file