Replace text in a imported file through SSIS

Hello,

I am importing a flat file through SSIS and doing some processing and export it to SQL table. I have a few date fields in the file, I import them as text and eventually put them in the SQL table as a date field.

The problem I have is some of the dates in the date fields are sent to us as "9999-99-99", and thoes don't work, they just show up in my table as null, so what I would like to do is replace "9999-99-99" with a valid date like "2013-01-01".

So I was wondering if anyone had any suggestion on how to do this, without creating a staging table or changing the dates in the actual file.

Thanks,
Sam