Forum Discussion
Anonymous
6 years agoNot applicable
Upgrade the DataWarehouse with SSIS
Hello I don't know if this question corresponds to this forum but I can't fix this problem, see if anyone can help me. To update my DW I use a scheduled task that runs all .dts for each of the fact...
- Anonymous6 years ago
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
v-lionel-msft
Community Support
6 years agoHi Anonymous ,
Please create support ticket .
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.