132 How to convert YYYYMMDD value to datetime in SSIS

How to convert YYYYMMDD value to datetime in SSIS

LEN(DateOfJoining) == 8 ? SUBSTRING(DateOfJoining,1,4) + "-" + SUBSTRING(DateOfJoining,5,2) + "-" + SUBSTRING(DateOfJoining,7,2) : NULL(DT_WSTR,20)

https://drive.google.com/drive/folder...
SSIS Tutorials:    • SSIS Tutorials  
SSIS real time scenarios examples:    • SSIS real time scenarios examples  
SSIS Interview questions and answers:    • SSIS Interview questions and answers  

How to convert YYYYMMDD value to datetime in SSIS
convert YYYYMMDD to datetime in ssis
How to convert a string to datetime in SSIS?
How to convert string yyyymmdd to datetime in SQL Server?
What is the format of Dt_date in SSIS?

Happy Learning.

If you have any questions or suggestions please comment on the video or write to me at “[email protected]”