Hello. I am looking into using the ODBC import to build a local "cache" table for items in my database. When I setup the script in my server published database, I don't see the ODBC connection I have setup on the server (like I do when I go to the ESS screen). Instead, it only shows local client drivers on my machine.
How would the server-side script run in that case?