I will look into deeper.

Basically it seems as if the columns are being add to the same file over the years.

I mapped to the latest file (ex. File_03312012.txt contains 90 ) (ex. File_06302012.txt contains 99)

The file with only 90 columns is only importing half of the rows.

This pattern occurs through the process. Will do deeper analysis to where exactly they are falling.

Quite tedious at times. Any logic for incoming columns or checking the file before SSIS ingests.

I would believe that the process would fail but it is not failing. The files are tab delimited