I am working with a single days worth of call records and my load script with intervalmatch is working just fine. When I run the script for 6 months worth of data, 30+ million records, the same data I validated before that worked no longer does.

"The Autonumber() function converts the string to an integer that takes a lot less memory space."

The use of AutoNumber(AgentID & ' | ' & Num(StartDateTime) & ' | ' & Num(EndDateTime)) as [AgentID+Interval] really helped speed things up and use less memory. It made me also think of other areas I could save on memory consumption earlier in the load script.

Thanks

But now you spawned a new question I will open a new post on in regards to intervalmatch and incremental loads.