September 19, 2008 at 4:42 am
I have created a script task in Sql 2005 SSIS package which is creating excel sheet and stored in a shared path. This package has been deployed in a server and it is executed by a Job. When i execute a deployed package separately, it is runs successfully. But its executed through job, it always fails. i'm getting the error message like "Executed as user : ServerName\System. The package execution failed." Can any one tell me what is the exact issue and the solution to solve this.
September 19, 2008 at 6:59 am
These issues are usually permissions problems.
Make sure the SQL Agent service account can access the shared folder.
September 21, 2008 at 10:43 pm
Check the account credentials you used for deploying the package, this might not have the permissions to execute the package
September 22, 2008 at 11:40 pm
hi,
For running a package as a job.user must have the windows authentication enabled for the particular datasource or database which he was using for the package..Check for the authentication,it will solves your problem..
vijay
September 23, 2008 at 3:31 am
Thank you for your valuable information and support. It solve my problem.
Regards,
Hari
________________________________________
From: vijayalaya cholan [mailto:elegantkvc@yahoo.com]
Sent: Tuesday, September 23, 2008 12:54 PM
To: Hari Arumugam
Subject: Re: SQLServerCentral - New Email (SSIS - can't run jobs)
hi Hari,
Go through the below link..might solves ur problem
http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx
vijay
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply