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
timokeeffeAsked:
Who is Participating?
 
JRManConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.