Hi Michael,

Thanks for your help with this! I've tried using Access but found that Access doesn't update the odbc-linked tables dynamically - it has to either be done manually or done using the Windows Scheduler. Unfortunately, the Windows Scheduler also needs to lock the Access db exclusively and that was creating a problem when the Access db was also linked to another platform. I tried creating a Linked Server in SQL server using an Access db anyway and starting running into other problems so I'm just backing quietly out of the rabbit hole I've gone down.

I really hope I can get Adagio hooked directly to SQL Server - we were told that it's definitely possible and I have to think that there's someone out there who's done it.