I have a source table that has some millions of rows and the job runs the SSIS package to load the data daily.
Now the daily job is taking for hours to run the entire load due to several rows.
I want to just do the incremental logic on the SSIS package I run.
I just want to capture the records that are modified/added on that day without reading the entire data.
Is there a way to do it?