• 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!