Click here to Skip to main content
16,016,962 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 have tried:

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.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900