You have to do this in BIDS. I do not believe the import wizard gives you much flexiblity.
You need to use a derived column and then use split string functions to cut up the string and reformat it in a way SSIS understands. Which is yyyy/mm/dd
You could use a script component but the above is simplier.
Save the package created by the import wizard as a starting point.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!