SSIS Dimension Load RRS feed

  • Question

  • In the current scenario I'm loading multiple dimension tables under a single ssis package. As all the dimensions are independent to each other, i have created a sequence container for each dimension load which contains an execute sql task for truncating the table and DFT to load the dimension table. There are multiple sequence container inside the package which is loading several dimension tables are running in parallel.

    If any of the dimension load is failing, after fixing we have to re-execute the package and all the dimensions are loading once again. Instead i want to run only that sequence container which should load only that dimension instead of running everything.

    Can any one suggest me the better way to handle this issue?


    • Moved by Dave PatrickMVP Thursday, September 3, 2020 12:28 PM looking for forum
    Thursday, September 3, 2020 12:18 PM