I'm using the legacy package deployment mode for a SSIS package that makes a very simple job : Copies on excel file from source location A to destination location B. This works as expected but when I'm trying to call the dtsx package from SQL server Agent's Jobs using a configuration file that contains different variables than those defined in design time this fails. The error message is
Started: 1:20:18 ?? Error: 2021-06-19 13:20:20.08 Code: 0xC002F304 Source: Copy Excel File System Task Description: An error occurred with the following error message: "Could not find file 'D:\Work\Excel\Source\SalesPersonsReport.xlsx'.".
I have used the CreateDeploymentUtility that exist on Project Properties as well as pointing to the configuration file during the creation of the SSIS execution step on SQL server job but without success