Archives of the TeradataForum

Message Posted: Wed, 19 Jun 2002 @ 18:02:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

--Jason

	<Prev	Next>		<<First	<Prev	Next>	Last>>