Now I think the issue happens in the last field which presumably is 20 characters but in the case the value is single digit it uses only 1 character, however, there are cases that it has a large number as its value, like 1631571 instead of 0

That will automatically push the 0D 0A.

That also means the csv is not completely fix-width for all columns, there is an exception to be handled, either in bulk insert format or in SSIS design.

The SSIS design works fine until it hits the special line and screws up after that line.

Any idea for this?

I am attaching the csv here for easier to understand. I changed .csv to .txt so it can be uploaded.

Thanks to all replies.