July 16, 2010 at 7:41 am
I'm getting a failure when my devs call my package.
The failure is:
Message: The specified @job_name ('Cenlar_SSIS_Import') does not exist.
Failed to start [Cenlar_SSIS_Import]
The EXECUTE permission was denied on the object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'.
How do I fix the permissions?
July 17, 2010 at 4:11 am
Before running the package set the package property Protection Level=DontSaveSensitive hope this would solve your problme,else reply back
---Syed
July 17, 2010 at 4:11 am
Before running the package set the package property Protection Level=DontSaveSensitive hope this would solve your problme,else reply back
---Syed
July 17, 2010 at 4:11 am
Before running the package set the package property Protection Level=DontSaveSensitive hope this would solve your problme,else reply back
---Syed
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply