Hi @Robert Oswald ,
*.csv/txt flat files always have host of problems where column delimiters, column separators, invisible characters like null terminators \0, special characters based on encoding, and line breaks are in the middle of the actual data.
The most reliable format for data feeds is XML enforced by XSD. An XSD (as a data contract between sender and receiver) will guarantee data format, enforce data quality, and prevent unexpected changes.
SSIS has XML Source Adapter for XML files intake.