• Thank you Jason,

    I had the 'opportunity' to be in meetings for about 7 hours yesterday and didn't see your reply until just before time to leave for the day...

    But thank you for pointing out that I was using the wrong formula to convert. I guess if you have a lot of stuff you have been copy and paste, make sure you paste the right thing into the little box... Your formula is what I intended, not exactly sure where I used came from.;-)

    In the Derived Column task I don't see a way to change the data type. Do I need to add a Data Conversion task as well?

    And I'm beginning to think the data isn't DOS/ANSI format. I get what appears to be data type mismatch. I'm having someone see if they can convert it to DOS/ANSI or at least verify that isn't the problem.

    Thanks for pointing out my error, and for assistance. I'll keep trying and see what happens. I'm not a heavy user, not this is heavy lifting, but I don't have any local help either.

    Norman