How to load unstructured data using ssis

[Mukunda113]

I have a requirement to process unstructured files using ssis.

Input File Format:

ID*Name*Sal*Details~*~
1*ABC*100*Validation Success~*~
2*BDC*200*validat
success
Faild~*~
3*FGT*300*Failure~*~

Output: 

ID	Name	Sal	Details
1	ABC	100	Validation Success
2	BDC	200	validat success Faild
3	FGT	300	Failure

[#2]

I don't think it's possible with SSIS default tasks, but you could try it with a .NET script task to parse the data.

[#3]

Thanks olafhelper for the response.
Any .net code snippet to parse the data

Thanks in advance

[#4]

Any .net code snippet to parse the data

---

@Mukunda113 , not really, it's a lot of work.

Mini example: File.ReadLines Method (System.IO) | Microsoft Learn