Date Field Error during Load Oracle Data into Microsoft SQL server through ODBC
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.
__________________
regards,
|