I wish to put the result of a query in Excel then send it to a number of persons at a specified moment. I've started by the configuration of all this on a SSIS package, till then everything is all right, all steps are going well. The problem appears when I tri to schedule this work via the SQL Server Agent.. You'll find below the steps i've done :
1- On the general part, I name the job and put the account sa as owner.
2- On the Steps part, i create a new step and then I set :
2.1 the name of the step.
2.2 Run AS = SQL Agent Service Account
2.3 On the general tab, I put the source of the package as a System File, I browse the package, then i save all.
When I tri to execute the Job, I receive this error (On job history) : "The JOB Failed. The Job was Invoked by user NomDuServeur\Administrateur. The last step to run was Step 1." ==> "Executed as user : MonDomaine\Système. The package executon failed. The step failed." :|
FYI : I'm using SQL Server 2005 with the OS Windows Server 2008 R2 64bit.
Could you help please ?
Thanks and regards.