Open up the properties of your data destination. Go to "Error Output", and see what you have set as the "Error" property.
The options are:
Fail component
Ignore failure
Redirect row
"Fail component" will fail the whole step, and will direct the package down your "red arrow" path. "Ignore failure" will do exactly that, and will allow the step to succeed. What you want is "Redirect row".
Take a look at this for details: http://msdn.microsoft.com/en-us/library/ms141679.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon