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~*~...
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 advance
Any .net code snippet to parse the data
Thanks in advance
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
