Forum Discussion
How to load unstructured data using ssis
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 |
- 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.
- Thanks olafhelper for the response.
Any .net code snippet to parse the data
Thanks in advanceAny .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
