Bingo!!! There were some blank fields so it was trying to set // to a date. I placed an If YYYY<>"" then .... and it worked great.

Thanks so much for...

That does make sense. Since I am a VB guy. Below is what I have done. It runs but complains about converting string do date.

Dim LastUpdate...

Okay I put the scrip component after the derived column and before the destination. I go into the script component and select the column then go to design script and...

Row.LastUpdateDateOut = CDate(CStr(CType(yourdatestring, Date)))???

I do not understand where to put this? What step in the package does...

If I do not try to convert the field type but leave it as char it works. But is it safe to leave a date field as char? I have...