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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-26 : 08:37:28
|
| young writes "HiI'm doing a DTS import on tables from an informix database to SQL. (SQL 2000 on windows 2000)But getting the following errors with date fields.----------------------------------------------------------insert error column 170 ('dlcust_date2',DBTYPE_DBTIMESTAMP), status 6: data overflow.invalid character value for cast specification.---------------------------------------------------------I need to be able to import the dates and also be able to use them as datetype dates. Thanks in advance.Young" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-26 : 08:52:03
|
| Check you transformation and the datatypes is the data in informix in a format that sql can understand and covert. If not then you can do an activex custom transform for that particular column instead of just a copy column transform. You can right click on the transform, remove the old transform for the column in question and an a new activex transform then go to properties edit the code to cast the data correctly and you should be good from there. An alternative would be to convert the date to iso standard (yyyymmdd) on the informix server and then it should work. |
 |
|
|
|
|
|
DTS import of dates