Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmarandon
Starting Member
1 Post |
 Posted - 2007-03-23 : 09:38:43
|
| Hi,I'm getting nut with excel date format on import !!!I have an excel file with a date column DD/MM/YYYYWhen I create a connection to the excel file to read this column, it changes the date format to MM/DD/YYYY (I put a dataviewer just after the source connection in the dataflow component).All my local LOCALEID are set to English UK. I tried to change the administrator account language to British and it changes nothing.The most weird is when I do a preview on the Excel sheet , the date is OK.The result is that when I insert the date in the DB, all date where the day can be a month are wrong (MM/DD inspite of DD/MM).Any clue ?Chris |
|
|
|
|
|
SSIS excel import date format pb