Tables from AS400 to SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Tables from AS400 to SQL

Author

Topic

mlafontaine1
Starting Member

1 Post

Posted - 2007-01-26 : 09:36:33

Issue 1: We are having trouble with date conversions from AS400 libraries that set default null value to 1901-01-01 and MS SQL sets it to 0001-01-01. This causes an error in the DTS package so we have to write a query in the DTS to bring it over as varchar then set the value to Null if = 1901-01-01. Once the data comes over, we then have to cast the dates as date time again. How can I bring it over as date/time but fix the default dates?

Issue 2: Dates coming from some fields don't have rules on the GUI to prohibit weird dates like 0201-02-11. We don't want to manipulate the data source, but short of an exception report to provide anything not null and not between 1902 and 2007, don't know what else to do.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources