How to Implement Late Arriving Dimensions in SSIS 2022

libpekin 86 Reputation points


I'm looking for end-to-end documentation, if possible, with demo packages on implementing Late Arriving Dimensions use case leveraging the Inferred Flag approach in SSIS 2019/2022.

I've been researching this for a while, and although there are numerous blogs/articles on the subject, they all seem to fall short on how this is implemented in SSIS with tangible examples.

Any help is appreciated. Thanks!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points

    Hi @wiseguy,

    Kindly check if this blog is helpful.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.