DateTime Validation in SSIS using conditional split
Hi, 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. Thanks, SandyLeoSandyLeo
October 25th, 2010 6:19pm

Add a data viewer before the conditional split component and take a look at what the data looks like before it goes into the cond. split. You should be able to find your answer there, and then be able to write an appropriate expression to catch the scenario. Right-click on the path going into the cond. split and select data viewers... Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2010 6:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics