Forum Discussion

Copper Contributor

Jun 02, 2024

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~*~...

olafhelper

Bronze Contributor

Jun 03, 2024

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.

Mukunda113
Copper Contributor
Jun 03, 2024
Thanks olafhelper for the response.
Any .net code snippet to parse the data

Thanks in advance
- olafhelper
  Bronze Contributor
  Jun 03, 2024
  
  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