Date Field Error during Load Oracle Data into Microsoft SQL server through ODBC

[wangxn]

For the Date field in Baan(we use Oracle database), if it is empty, Baan store it as 01-01-9999, which is not suport by microsoft SQL sever.
i need to download the baan data into SQL server, but date field is always problem, Baan said i should write a view for that, but i don't think it is practical since i am not sure when and what table i need to download and besides, Baan has so many tables, every table has the same problem if date field is empty.

Any body has bright idea on how to write a VB script, for instance to check the date field during loading, let's say i am using DTS tranform function of Microsoft SQL Server.

[richard]

You can first download the whole base, change the oradata parameter in db_resource like this oradate:1 and reload the base.
After that the date will be stored as 1 JAN 4712BC.

There is a case opened in the baan KB.

Regards

[richard]

Sorry.