Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

DTS Import to SQL Server form AS/400 Date Coversion issue

I am trying to do an import Order History tables from a JDE Edwards system on on AS/400. when I did this transfer all the data came over fine yet my date fields in JD Edwards

example: 10/22/2003

did not translate correctly, they became numbers which were not related to the date. Any Idea how to work this conversion issue from AS/400 -> SQL Server
0
timokeeffe
Asked:
timokeeffe
1 Solution
 
JRManCommented:
I think this is because SQL Server does not recognize the date format 10/22/2003
See the SQL Server Books online to find out what is the default server date format on SQL Server. This can be solved either be changing the default date string format or converting the AS/400 datefield on the fly to the recognizable date format for SQL Server using the DTS script.  Hope this can get you somewhere...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now