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:
IDNameSalDetails1ABC100Validation Success2BDC200validat
success
Faild3FGT300Failure
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*validatsuccessFaild~*~3*FGT*300*Failure~*~ Output: IDNameSalDetails1ABC100Validation Success2BDC200validatsuccessFaild3FGT300Failure Read More
