Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    6 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.Trabajo.jpg2.jpg

    Then this package calls other packages here:

    3.jpg

    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