Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: SQL Server datetime fields to Teradata?
 
From:   Jason Fortenberry

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016