Member 13867163 Ответов: 0

Проверка исходных данных excel в службах SSIS

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.

0 Ответов