I have a variable which holds the path for an excel file.
I have set the value to work on my local machine.
When I deploy the package the hard coded value is no longer valid. I reset the value using a SQL Package Configuration table.
Is this the correct thing to, or should I map to a valid file path when deploying the package to the server?