Load excel files incrementally using SSIS Data Flow Task and Slowly Changing Dimension Transformation.
Download the source file used in this session from below link.
https://github.com/virtbi/Source-File...
In this session, let's try to understand the Project and Source file data.
Please note that, the source file and the analysis I made in the session is for demo purpose only, real-time use case scenarios may vary based on actual business cases.
Hope you try to understand the technical approach that we followed to solve or automate these type of tasks.