That's great news.  Now stop eating crisps and finish the job 🙂

Hi,

If you already have the data in a table and can guarantee the order they hit ssis, you could use a script component to check the value of line type....

Hi,

Thank you both for your feedback.  It has been very useful.  I did consider an SCD in the product dimension but after digging deeper, it isn't data that is suited...

Koen Verbeeck (10/4/2016)

I found the book "Star Schema...

Hi,

Thanks for your input.

In an ideal world, yes, the lines would...

Thanks for your input.

I think I'm at the stage where I'm realising the models and advice in my books are based on best case scenarios. Like you said, I...

Hi SSCoach,

The orders are imported into the same transactional system and the system gives each imported order a unique internal sales order number.

I see your point about the timestamp, this...

Hi,

Thank you both for your replies, I really appreciate your input. I see now there is no set rule and this is more of a requirement question. So...

Hi SSCrazy Eights,

Thank you very much for pointing this out, exactly what I needed. I have been able to solve the problem and learnt so much more along the...