July 21, 2008 at 11:30 am
Hi,
I have scheulded a maintainance plan in sql server 2005 enterprise edition to copy data
but the job is failing due to the error "Executed as user: The package execution failed. The step failed."
everything is correct dont know y its failing.
my sql version is 9.0.1399 with sp2
pls help
July 21, 2008 at 12:28 pm
Under what account is SQL Server agent running? Does this account have permission to execute this job?
July 21, 2008 at 1:19 pm
Hi,
running under admin account only
July 21, 2008 at 4:39 pm
Where are you copying the data to/from? Does the SQL Server Agent account have rights to those folders?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply