SSIS 2008 Data Flow error catching

Hello,  I am converting dates from YYYYMMDD HH:MM:SS.00 format to a SQL Server datetime field in my SSIS 2008 package.  I have it working correctly, but now I am adding in error catching.  I tried to redirect rows, but it redirect the whole file - instead of just the bad ones.  I created a text file with a mix of good and bad rows, but I cannot get it to process the good ones only.

I gave up and changed the redirects to fail component, the way it was at the begining.  But now, the data flow stops at the date conversion in red - and does not return to the control flow where I have another task to move the bad file to a "Hold" subdirectory.   How do I get the flow to continue after an error inside the data flow?  It just stops and does not finish with the Failure constraint I have. The task never gets executed.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Do the redirection where you're doing the formatting... the formatting error will allow you to catch just the exception errors.

As you can see, I have 2 different error outputs, one on the format and another on a business rule.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Reza RadConsultant, TrainerCommented:
put a screenshot from dataflow running status.
Did you configured error output on data conversion transformation?
Alpesh PatelAssistant ConsultantCommented:
Do the redirection of error rows in Dataflow area.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.