September 24, 2012 at 8:35 am
When I execute ssis package that errors in schedule job manually, it completes normally. Inside scheduled job I receive the following;
Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'sa'.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:15:00 PM Finished: 10:15:00 PM Elapsed: 0.437 seconds. The package execution failed. The step failed.
This job backs up 2 databases & then ftp's them to a different server. I've googled this error & haven't found any resolution. Any help would be appreciated as I am not the best SSIS person.
thx
jude
September 24, 2012 at 11:46 am
It looks like you're running into an issue with a stored password. Are you saving the sa password in the Connection Manager in the SSIS package? If so then what Protection Level are you using? Setting the Protection Level of Packages. If you're using either "user key" option that could be the issue. Your user key will not exist on the server for the Agent job to use. Can you post any previous or subsequent errors output by the SSIS package?
As an aside I would recommend using a Windows account to run admin packages like this instead of using the SQL Authentication. If you're going to use SQL Authentication make sure you never store the password anywhere in clear text.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply