timokeeffe
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.