I have a fixed length text file and it contains around 5 columns. I’m able to process successfully by using SSIS flat file with Fixed Length.

The problem is if later any one added new column in the source file or changed the length of the existing columns, that time I again need to re-design ssis and deploy to prod.

So, I’m looking any other option to process this file other than SSIS ? With minimal changes when is there any format change in the source file.