I am importing a excel file and tryinng to convert data types to match the database types.
I have a date field in the source file. I used DB_TIMESTAMP during data conversion.
But when I run the package, it throws error on the rows where the date field is empty (ie, there is 'NULL' in the source file)
Also how do I make sure that the date is in mmddyyyy format?