Forum Discussion
Upgrade the DataWarehouse with SSIS
Hello @FarhanAhmed ,
All packages have the same path with the same configuration file, the problem is that it will be put on different servers so the routes will change, so when the main packet calls the other packages has to pass the path with the configuration file.
The main package runs in a job and there you can pass the configuration file, as seen in the image.
Then this package calls other packages here:
The package companies is to which I am not able to tell the path of the config file, by dfecto has the local mia.
Thanks a lot
Community ChampionYou may create on global "XML" configuration file for all of your DTS/SSIS packages and map path variables in each SSIS Package and use that in datasources/destinations.
https://www.sqlservercentral.com/articles/simple-steps-to-creating-ssis-package-configuration-file
Hello @FarhanAhmed ,
All packages have the same path with the same configuration file, the problem is that it will be put on different servers so the routes will change, so when the main packet calls the other packages has to pass the path with the configuration file.
The main package runs in a job and there you can pass the configuration file, as seen in the image.
Then this package calls other packages here:
The package companies is to which I am not able to tell the path of the config file, by dfecto has the local mia.
Thanks a lot