Before I suggest anything, I'd like to be sure I know the problem. There's a really good article on Subclassing by Rebecca Riordan (but she's implementing it in Access -...

Okay.
SSIS just baffles me. How much RAM am I supposed to have for this? If I open a Script task, it takes like 15+ seconds to close again. WTH???!!!...

Oh, okay. I'll give it a try. (Remember when MSFT used to be really explicit about which version of a program was installed and you could go to help>about and...

Do I seriously have to create a DSN for this to work?

Thanks Federico. I downloaded that and installed it,
I created a connection using the Source Assistant and could only connect to the database at all using the SSIS provider. But...

Please post the table definitions for the relevant tables. What you're doing sounds way harder than this should be.

Isn't it as simple as DIVIDE(COUNTROWS('OrderLineItems'),COUNTROWS('Orders')) ?

This?
SELECT SortOrder, country, colour, amount
    , DENSE_RANK() OVER (ORDER BY SortOrder) AS rn
FROM #testing
ORDER BY SortOrder
        , Country
        , Colour
        , Amount

Oh wait,...

I wouldn't back up the structure to Access. There isn't a perfect 1:1 object mapping between the two. Why not just script out all the objects so you have all...