August 20, 2008 at 1:26 pm
I have a fairly simple SSIS package that creates a text file, then FTP's it to a client's machine. The problem I found is that recently the IP address to the server changed, and for some reason SQL Agent did not report the package as failing.
If I run the package outside of SQL Agent, i can clearly see the FTP server connect error it should have thrown, but for some reason SQL Agent keeps reporting 'success'. On the Advance Tab of the sql agent job, i have "On Failure action" set to "Quit the job reporting Failure".
The FTP step has the StopOnOperationFailure flag set to True, but i did notice that the FailPackageonFailure flag is set to false, but that seems to be default.
Help! Did I miss a flag somewhere that could cause this behaviour?
August 21, 2008 at 1:19 am
What is the maxErrorCount set to?
If you run the package through cmd, what is the result?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 21, 2008 at 8:06 am
Crispin Proctor (8/21/2008)
What is the maxErrorCount set to?If you run the package through cmd, what is the result?
Maxerrcount is set to 5! Me thinks that may be the problem....
August 21, 2008 at 8:10 am
Unless it fails 6 times 😉
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply