May 10th, 2004, 11:31 AM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
AS400 Link to SQL
Good morning all,
In my AS400 source I have tables with date fields, if I import a table with a package to a text file, there are dates like "0001-01-01". Before I import directly my AS400 tables into Access without problems because Access read those dates as "1901-0-01". Now we have to move to a SQL server. If I try to import with SQL Package it crash unless I first change the fields in my SQL table to varChar(15), do the importation, change the value "0001-01-01" to "1901-01-01" and then alter the data type back to smalldatetime. I have a lot of tables with numerous date fields. I try to link the AS400 source to my SQL Server, I still could not read tables that have dates like "0001-01-01". I could not do modification to the AS400 source. Is there a way to solve that problem?
Thanks.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
