SSIS FTP Task not failing through SQL Agent

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Crispin Proctor SSCoach Points: 18161 More actions · Answer 1

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!

ManicStar SSCoach Points: 17992 More actions · Answer 2

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....

Crispin Proctor SSCoach Points: 18161 More actions · Answer 3

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!