I am facing issue with null validation for DateTime. I have input csv file which contains DateTime field as Date datatype. In the destination database table, I am storing this field as datetime. I am using conditional split feature of SSIS
package and try to validate this field before inserting into the database.
The value which is going into the db is "1899-12-30 00:00:00.000". I dont know why?
I have tried various expressions like ISNULL(DateTime), LEN(DTSTR, DateTime) == 0, ISNULL(DateTime) ? False : DateTime. Nothing is working.
Req is simple, if date is valid insert in db otherwise write is as bad data in error log file.
Can anyone provide suggestion on this.
View Complete Post