March 14, 2008 at 9:04 am
hi guys, i hope you can help me, i created an ssis package in which it creates an excel spreadsheet, then this package zips this report by a vb script, everything works fine when i run it manually , but when i try to run it by a job it doesn't work.
March 14, 2008 at 9:21 am
Does the agent account have the appropriate rights? You should setup a proxy with the appropriate rights to run the package.
March 14, 2008 at 9:23 am
Well, what doesn't work? Do you get any error messages, anything in the job history or the package log? More information will get you more help.:)
Greg
March 14, 2008 at 9:48 am
i get no errors, in the job it comes out as ran successfully.
March 14, 2008 at 9:52 am
You need to check the job history. Right-click the job and view the history. If it is not working it should tell you why in there. I think you are encountering a permissions issue. When you run the package in BIDS, you are running it with your credentials; however, when it is scheduled as a job, it is run under the agent account. The agent account does not have the same rights as you. You can setup a proxy account with the credentials needed to run the job and select the proxy in the jobstep RunAs dropdown.
Addtionally, how do you have your job steps setup? You do not have continue on error setup do you?
March 14, 2008 at 9:54 am
For example does the Agent account have access to the directory where you are creating the Excel spreadsheet?
March 17, 2008 at 7:01 am
indeed it was a permissions issue! thank you soo much!
March 17, 2008 at 7:08 am
NP, glad I could help.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply