Post reply

Schedule job not working

  • August 23, 2007 at 3:56 am

    #118223

    Hi

    I have an SSIS package that exports data onto a csv file. I can run the package manually and it succeeds but when I schedule a job to run this package I get this vague error:

    The package execution failed.  The step failed.

    Does anyone perhaps know whats wrong here? If u know pls explain to me in detail as I am not very familiar with SSIS.

    Regards

    IC

  • August 23, 2007 at 4:44 am

    #728847

    Imke

    I imagine it's because the owner of job (or the login that SQL Server Agent uses) doesn't have the same permissions to execute the step as you do.  That's why you can run it manually but it doesn't work when you schedule it.

    John

  • August 28, 2007 at 2:37 am

    #729708

    Imke,

    Check the package properties. The security settings- Protection Level defaults to Encrypt with USer key. So if you are executing the job with a different role, the package fails. So Change the protection level settings in the package to 'Dont Save Sensitive'. This way, the package will work even if you are executing the job with as a different user.

    Hope this helps.

    ViVa

    Warmest Regards,

    Vv

  • August 28, 2007 at 2:49 am

    #729710

    Hi,

    Thanks, but can you perhaps guide me step by step. I click on the package on SSIS, the properties display on th bottom right. I see Execution, Forced Execution Value, Identification, Misc, Transaction. I am looking in the right area because I don't see the Security Setting there.

    Regards

    IC

  • August 28, 2007 at 5:20 am

    #729728

    Hi,

    I think you clicked on a task and looked at the properties for the task. Click on empty area in the package and make sure the properties window has the name of the package. Then you should be able to see a category Security in the properties window. Under that you have Protection level property. Change that to Dont Save Sensitive. (depending on the security level you want to set for your package).

    This link gives you more options for executing the package as a job. http://support.microsoft.com/kb/918760 

     

    Thanks,

    Vv

    Warmest Regards,

    Vv

  • August 28, 2007 at 6:03 am

    #729735

    Thanks, I changed the Protection level to "Do not Save Sensitive". The scheduled job is still not working.

    Any ideas?

    Regards

    IC

  • August 28, 2007 at 9:39 pm

    #729961

    Try out the other options mentioned in the link - http://support.microsoft.com/kb/918760.

    Warmest Regards,

    Vv

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply