had a problem with process the package

Question

had a problem with process the package

sivaramakrishna1986

SSC Enthusiast

Points: 173
More actions
February 20, 2011 at 12:08 pm

#149961

Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "Flat File Destination" (237)" wrote 0 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Data Flow Task
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
i dont know what it means ... can u please explain me
thank you

Viewing 10 posts - 1 through 9 (of 9 total)

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

Anjan Wahwar SSCommitted Points: 1617 More actions · Answer 1

Hi,

This error description indicates that three tasks in you SSIS package got failed that leads to failing the entire package.

Setting property MaximumErrorCount = 1 indicates, inside this package scope maximum allowed error count is 1. Meaning, if more than 1 task will get failed in package, will leads to failing the entire package. If you want to ignore this then set the property value to 3 or more.

"SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "Package.dtsx" finished: Failure."

Thanks

Anjan

__________________________________________
---------------------------------------------------
Save our mother Earth. Go Green !!!

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

To find the real issue here, you'll have the post the error messages, as they are currently missing.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246962 More actions · Answer 3

Koen Verbeeck (2/21/2011)
To find the real issue here, you'll have the post the error messages, as they are currently missing.

So you're not happy with the "just set the maximum error count to 1000" solution then? 😉

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Phil Parkin (2/21/2011)
Koen Verbeeck (2/21/2011)
To find the real issue here, you'll have the post the error messages, as they are currently missing.
So you're not happy with the "just set the maximum error count to 1000" solution then? 😉

Only 1000? Why stop there? Just reach for the theoritical limit and go for the maximum of the integer: 2billion+

You can go to your boss and say with utmost confidence:

"My packages never fail"

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 5

Koen Verbeeck (2/21/2011)
Phil Parkin (2/21/2011)
Koen Verbeeck (2/21/2011)
To find the real issue here, you'll have the post the error messages, as they are currently missing.
So you're not happy with the "just set the maximum error count to 1000" solution then? 😉
Only 1000? Why stop there? Just reach for the theoritical limit and go for the maximum of the integer: 2billion+
You can go to your boss and say with utmost confidence:
"My packages never fail"

Heheh, Max Error count = 0. What failure? 😉 (I do this for a transactional based error control that has its own error handling)

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Anjan Wahwar SSCommitted Points: 1617 More actions · Answer 6

Phil its totaly depends on the business needs (if I am correct :cool:). Sometimes we can afford to force our package to execute successfully, although some tasks got failed in the package just to make our workflow working.

Anyways guys let me know in case I am wrong, because you pple are expert in this.

Thanks

Anjan

__________________________________________
---------------------------------------------------
Save our mother Earth. Go Green !!!

Phil Parkin SSC Guru Points: 246962 More actions · Answer 7

anjanwahwar (2/21/2011)
Phil its totaly depends on the business needs (if I am correct :cool:). Sometimes we can afford to force our package to execute successfully, although some tasks got failed in the package just to make our workflow working.
Anyways guys let me know in case I am wrong, because you pple are expert in this.
Thanks
Anjan

You are correct. But bear in mind that the person posting the question was an ultra-newbie and your advice was directed at them, not at an experienced user. Your advice could easily be misused if the consequences are not understood, which is why we chose the safer path of advising the poster to understand and eradicate the errors.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

Phil Parkin (2/21/2011)
You are correct. But bear in mind that the person posting the question was an ultra-newbie and your advice was directed at them, not at an experienced user. Your advice could easily be misused if the consequences are not understood, which is why we chose the safer path of advising the poster to understand and eradicate the errors.

And after that, we choose the mild path of irony/sarcasm to illustrate our point 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Anjan Wahwar SSCommitted Points: 1617 More actions · Answer 9

Koen Verbeeck (2/22/2011)
Phil Parkin (2/21/2011)
You are correct. But bear in mind that the person posting the question was an ultra-newbie and your advice was directed at them, not at an experienced user. Your advice could easily be misused if the consequences are not understood, which is why we chose the safer path of advising the poster to understand and eradicate the errors.
And after that, we choose the mild path of irony/sarcasm to illustrate our point 😀

Thanks Guys.. I like the way you kept your point. 😀

__________________________________________
---------------------------------------------------
Save our mother Earth. Go Green !!!