SSIS Flat File Source

0
votes

Problem History I have a simple SSIS package which loads data from a flat file source(.csv) to a MS SQL Server table. Falt File Format

enter image description here

All of sudden our source system added a header and footer to the input file so the file now looks like

enter image description here

Question:

The current SSIS package did not fail and is working fine; On top of it - it is not loading the header and footer. How is that SSIS pacakage ignores the header and footer? should'ent the package fail?

1
ssis

1 Answers

1
votes

SSIS Flat File Source is very simplistic and basically ignores file format changes as far as it can - it only really cares about the row terminator. Column identification is positional. So I would expect it is skipping the first row, then passing on the 2nd row (Col1, Col2 etc) and the footer row.