Forum Discussion
Mukunda113
Jun 02, 2024Copper Contributor
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~*~...
Mukunda113
Copper Contributor
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
olafhelper
Jun 03, 2024Bronze Contributor
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