When you import the data apply a manual transform. Transforms use VBScript or JScript and you can fairly easily make a change like that as you are inserting into the table.