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
April 20, 2009 at 8:03 am
#980728
This example shows how to check for valid date and replace default date for invalid date.
(DT_BOOL)(DT_DATE)IssueDate_C ? IssueDate_C : "01/01/1900"