CODEWITHSUNDEEP
ssis
S..
S..

Reputation: 1272

SSIS Flat File Source

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?

Upvotes: 0

Views: 264

Answers (1)

Mike Honey
Mike Honey

Reputation: 15017

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.

Upvotes: 1

Related Questions