Тема: 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?

Any idea?

Please help.

I didn't find the right solution from the Internet.

References https://social.msdn.microsoft.com/Forum … onservices

2d animation company