Converting Dates During DTS Import

[RobS23]

Hi

How do I go about converting a US date in a CSV into a UK date on DTS into SQL Server?

I've had a play with transformations but it doesn't seem to like them in the slightest

Should I go with my instinct and "massage" the dates initially as varchar in an intermidiary table first?

 

[yksvaan]

Yes, load csv into a temp table and from there on you can use CONVERT function to convert us datestring to SQL datetime datatype.

Or make a vbscript transformation for this column and program it there with vbscript functions.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]