Im looking to simply modify an SSIS package to include import of a changing xls file.
I require that the process to truncate and Import ecel files into the database. The .xls columns change and are dynamic, if data for those columns is not present the column is not included in the file, therefore I need the package to import based on how the filelooks.
See zipped file for details I have included a few file examples in folder 1 & 2