In package i have one Data Flow task which execute an SQL query and return some columns.
I want to check value of one of the Source column, whether it is 1 or 0. If the column value is 1, then insert the record in table Source_Error_tbl (redirect error record) If the column value is 0, then insert the record in destination table (general flow)
Can anyone help on how can we implement this if-else condition inside data Flow task ??
Precedence constraint i checked, but it cannot be implemented inside data flow task.