Conversion of timestamps from SQL Server 7 to Teradata

[Ravenium]

Well, after reloading the schema as was suggested, we have begun the data transfer process from SQL Server 7 to Teradata. We would like to do this in Powerbuilder, as it offers greater control over how the table contents are imported and in what order. However, we are getting "error: invalid operation on an ANSI Timestamp field" and "Timestamp overflow" errors when trying to execute the data pipeline. I noticed the format of the date on NCR's system seems to favor the yyyy/mm/dd as opposed to SQL Server's mm/dd/yyyy format, so perhaps this might be part the problem. We have been able to manually transfer tables over from within Sql server 7 itself using the export utility, but the process seems to crawl (25,000 records took over an hour to process vs 5-10 min from SQL Server 7 to other databases).

Any ideas? We're pretty stumped.

-Barry

 

[BillDHS]

Teradata default date format is 'yyyy-mm-dd'. Two items to review, make sure your timestamp is defined TIMESTAMP(6) which indicates 6 decimal place times. Also in your insert/select task use a format comand on the date fields:
BeginDate (date, format 'mm/dd/yyyy')
or whatever format your output from the source is in.