i need to put a condition in conditional aplit transformation editor in ssis 2005.
condition is to check whether the date is invalid or not. date is in dd/mm/yyyy format.
the condition i put((DT_DATE)"06/06/2010" > (DT_DATE)[Data Conversion 1].[Scan Date ]) is not working..
"[Data Conversion 1].[Scan Date ]) " is the field name
help me to solve this