The short answer is that it can probably be done without writing any significant code or using a script component.

It will really depend on what you consider bad data and errors. If you post a few sample rows of good and bad data and what you would want to error messaging, it may be possible to give you some direction.