I am exporting the data from database to an excel template that will have 100+ columns and approx 4000 rows of data. Then the business user will make changes to some columns without modifying primary key columns and will send back to us where we will update the same to database.
In order to this am using an excel template by protecting the primary key columns with a password protection.
At template level am fine and whenever am trying to modify any primary key column it's not allowing and am totally good there.
But when I use that excel template as a destination to load data from SSIS, all the protected columns are no longer protected and i could able to make changes. Please help me how to avoid this issue.