Date issues with importing CSV files to Mssql 2000

[prav5110]

Hi Guys,

I am importing a csv file to an ms sql server2000 DB. The format of the dates in my csv file is something like 22/01/2004. But when i import it to sql 2000 in a Datetime format, what i see in the db is 4/01/2022. Could i make some changes in the DTS package or perhaps use another Data Type so as to import it properly?

 

[johnherman]

Try this in the DTS forum for better results.

Sometimes the grass is greener on the other side because there is more manure there - original.