Hi Mark
I finally worked out what the problem was when I was getting the “Operation must use an updateable query” when adding the Connections in the browser. The ETL ODBC browser must run elevated at “Administrator” level. I changed the properties of the executable to allow this.
Thanks for all your help
Paul