Question on Job Schedule

Hi All,

I encounter the following problem :

I create a SSIS in VS2005, it can run successfully in there.

then i save the package into Server, and execute it. It still can be run successfully

then i make a job which run this package regularly, it run failure. Even I start the job manually, it also fail.

this is the message:
Date7/18/2007 5:41:24 PM
LogJob History (a)

Step ID1
ServerHITSQL034
Job Namea
Step Name1
Duration00:00:27
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0

Message
Executed as user: HITDOM00OICSQLAG. The package execution failed. The step failed.

I guess this is due to the Job Agent. But dont know how can i set it

Thanks,
Linus

Hi,
I feel there must be some permission issues.
Log says that job actually ran for 27 seconds which means it must have started the package.
Start the job manually and check under running packages in integration service.
This will imply whether the package actually gets executed by job or not.
Also have you specified any configuration files.

where can i set the permission for that?