I am facing some serious issue with SSIS package.
In My project, I am having one DFT where the source is table and target is a table.
there is another process which dumps the data from excel to stage table every month, and finally, I have to load data from that monthly table to target table
but the problem is, they frequently change the some of the column name in the source file and same thing happening with staging table. In that case, my SSIS package gets failed.
Now the requirement is to manage these things without the dynamic stored procedure.
below is the screenshot of target and source table structure.
I am desperately looking for this solutiion, thanks in advance.