Home Forums SQL Server 2005 SQL Server 2005 Integration Services convert datatype DT_STRING to DT_DBDATE in ssis RE: convert datatype DT_STRING to DT_DBDATE in ssis
peterk1961
SSC-Addicted
Points: 493
More actions
March 16, 2009 at 3:01 pm
#960609
I am assuming you are using expression column to change the data to datetime format. As part of that, check for null or valid date and move a default value if it is null or invalid date.
Peter Kennedy