I have created a DTS package on the Client with 'sa' rights and this DTS package is writing some output file on the Client's machine. Whenever I run the package from the the DTS wizard(F5) it runs fine and generates the output file at the desired location on the Client's machine.But the same process fails to run whenever I try to schedule it to run under the EM with the following : "Error = -2147220421 (8004043B) Error string: The task reported failure on execution. "
I already meet this problem and solved it by writting data on another machine. The sqlserveragent account was set with the same properties on my two servers (same OS, same everything...) but it worked only on one... But helpimstuck is right: First ensure your sqlserveragent account has rights to right data.