My source is Excel File. it has 3 columns as follows. ID Date1 Date2 Date 1 10/02/2018 10/06/2018 10/05/2018 2 10/05/2017 05/16/2018 10/02/2018 3 09/01/2018 09/04/2018 10/01/2018 Here the validation condition is Date should be in dd/mm/yyyy and second date should be greater than first date and third date should greater than second date. So After validation I should get the below Bad records. ID date1 date2 date3 1 10/02/2018 10/06/2018 10/05/2018 2 10/05/2017 05/16/2018 10/02/2018 in First record Date2 is greater date1 so it is wrong in second row date2 is in wrong format that is month is 16 so it is wrong. Please advise the correct method in ssis. Thanks
What I am doing is taken Derived column and mentioned datedif conditions and then using conditional split i am sending the records to a temp table and finally joining the columns using primary key column and taking the output. But this is cumbersome because if i have 2 to 3 columns it is fine if more than 3 columns becoming difficult.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)