Please tell me how I can GLOBALY change the default error handling to
just keep going.
It is far more important that I get the good rows then stop on one bad
one.

This error is reported from the Data Flow Control Flat File Source.

For some time, I have been changing fail on error to ignore anywhere I
can find it.
Sometimes, it seems that SSIS is changing it back.

I'm hoping that you know of some config option that will let me make
this change.

In the meantime.. what could possibly be wrong with an office name to
cause this failure?

Thanks,
IanO

Thanks for your reply,Todd.

Last night I was trying to use some data viewers. Every time I put one
on a success connector, BIDS crashed.

I took the datafile I was trying to load into Excel.
Then I used a text editor to cut the file. I ran the package with 5
records and it worked okay.
As I scanned the office name column in Excel, I did find some rows that
exceeded the default size of 50 characters.

For me, it is better to truncate one or two rows than to abort the
processing for thousand of rows. That is why I asked for a way to
default the ignore row option rather than the Fail Package option.

The system should work for us ...

IanO

Hello IanO,


So you should be setting the OnError for the columns in the Source Adapter
to Redirect the rows down the Error Flow. As Todd has said you can almost
debug this before you try to load by using a Row Count transform

BTW use Our's it's cooler.

http://www.sqlis.com/default.aspx?77

Send your rows to a No-Op destination like the trash destination

http://www.sqlis.com/default.aspx?56


In an expression then on the workflow after the Data Flow task decide what
you want to do. You could take a view that if the ratio of Good:Bad is less
than a given %ge then do not carry on.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Thanks for your reply, Allan.

I have no doubt that what you recommend is the correct course of action
in most circumstances. However, for the work I am currently doing, it
would be a blessing if you could tell me how to set the DEFAULT to
Ignore Failure rather than stop the entire process.

I have set it to Ignore Failure so many times only to find that SSIS
reverts to the failure mode.

For the future, how do I install your component?

Thanks,
IanO

Hello IanO,

The DEFAULT will always be "FAIL" Once it is setup to "Ignore Failure" or
"Redirect Row" and you save the package it should stay like that.

For installing any of our components you can read this article.

http://www.sqlis.com/default.aspx?56


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com