John Rowan (8/19/2009)

---

Then I would use a Derived Column transformation in your data flow to replace the existing values with the defaults when they come into the data flow as...

John Rowan (8/18/2009)

---

I suppose that depends on what you want to do with the invalid rows. If you have 10 rows in your file and 2 have invalid dates,...