>Yes, there is a way to deal if error rows. In the Output columns you can redirect rows instead of failure, to do data cleansing. You can add a derive transformation and or scripting transformation to do just about anything because these are row processing transformations.

Thanks, but as you might have seen in the other thread, the problem I am facing now is much bigger than the empty dates. I have a lot of date values from various fields below the minimum mark of supported date values in SQL Server. So, this would force me to apply a migration logic to handle the creation of additional field to hold a numeric equivalent of such date, convert that at UI time and such.

This is quite not encouraging I would say. I really don't understand why there is such a restriction about the date values.