ssis condition to verify the date column with the current date field "19670708" this should be the date format

Question

how to write the condition in condition split to check the person age below lessthan 18 years using the current date from source flat file

Answer 1

Hi @Naresh y ,

1.We can use Derived Column Transformation to convert the datatype of date and get age from date.

2.Then use Conditional Split Transformation to get the age less than 18.

Please refer to the following expressions and pictures:
1.Expression for New Birthdate:
(DT_DBDATE)(SUBSTRING(Birthdate,1,4) + "-" + SUBSTRING(Birthdate,5,2) + "-" + SUBSTRING(Birthdate,7,2))

2.Expression for Age:
DATEDIFF("yy",(DT_DBDATE)(SUBSTRING(Birthdate,1,4) + "-" + SUBSTRING(Birthdate,5,2) + "-" + SUBSTRING(Birthdate,7,2)),GETDATE())

3.
4.
5.
6.
7.

Best regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.