I agree on splitting the file first. But this also can be done in SSIS.

Read the file as if it just has one large text column. Pass it through a...