Тема: How to handle error of convert oracle datetime to sql datetime?
I am developing small tool to convert oracle table to SQL table, which is using SSIS.
however, a little issue is confusing me,
In Oracle database, if there is no value filled, the value will be '0000-00-00 00:00:00', which cannot be conver into MSSQL.
I would like to know, if there is any good methods to handle it via SSIS?
I didn't find the right solution from the Internet.