How to Implement Late Arriving Dimensions in SSIS 2022

libpekin 166

Hello,

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!

1 answer

ZoeHui-MSFT 37,441 Reputation points

2024-06-17T02:32:42.95+00:00

Hi @wiseguy,

Kindly check if this blog is helpful.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
libpekin 166 Reputation points

2024-06-19T02:19:38.8766667+00:00

Hi @ZoeHui-MSFT ,Thanks for the blog post. At first glance it seems very helpful. I'll implement and provide an update.

Strange that handling late arriving dimensions in SSIS isn't well documented by MSFT or in any of the SSIS web communities.

Thank you!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to Implement Late Arriving Dimensions in SSIS 2022

1 answer

Your answer