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
NINAD-411800
SSC Rookie
Points: 43
More actions
April 20, 2009 at 6:24 am
#980648
Hi,
Since the expression is cast to DB_TIMESTAMP, would it not fail for invalid date string?
eg. If the input string is 20090230 (which is an invalid date), how do you handle this in the expression.