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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2008-09-04 : 10:49:34
|
| Hi,I have the input file as 1,2,0001-01-01.The last field is the datetime column in the target table. If i map this input column with the destination column in the database which throwing error during transformation. Since i changed the input column as "database timestamp [DT_DBTIMESTAMP] datatype, i thought the problem would be, so went back and changed to DT_STR, it resolved my issue by converting my date from "0001-01-01" to 2001-01-01. Could anyone please explain why the reason for converting into valid date though its not valid. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-04 : 11:24:13
|
Check your setting on SQL Server.Default settings are that years starting with 00-49 should be treated as 2000 and 50-99 should be treated as 1900.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2008-09-05 : 01:09:36
|
| Could you please tell me where to check the settings in SQL Server 2005. |
|
|
|
|
|
|
SSIS - Flat file Input - Date field