• Yes each file has column headers.

    I'm retrieving the name of the file.

    Based on the filename it populates the correct table.

    The mapping is based on the file with the most recent columns which is greater to older files.

    Even the order of the columns change within the file.

    The package isn't failing but data is not loading correctly.

    I'm came across this article regarding loading changing files.

    I'm not the strongest programmer but seems I can give it a try to make the package more scalable.

    Let me know you guys thoughts

    http://blog.quasarinc.com/ssis/best-solution-to-load-dynamically-change-csv-file-in-ssis-etl-package/