Archives of the TeradataForum
Message Posted: Wed, 19 Jun 2002 @ 18:02:31 GMT
I have tried moving datetime data using DTS directly from SQL Server to Teradata in the past and have failed as well and am not aware that it is possible.
The 2 solutions I use then are
1. Create temp table on Teradata with timestamp(0) field changed to char(19). Then use DTS to move data followed by an insert\select with cast to move data from temp table to perm table with the timestamp field.
2. Export data from SQL server to flat file with an explicit select format of the datetime field as 'yyyy-mm-dd hh:mm:ss'. Then fastload or multiload the file into Teradata.
If you find another solution or if these raise questions please let me know.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|