In MGE 2008 and later you can use Unmanaged connections which allows you to set up folders on the server, define an alias to the folder and use that alias in a connection in Studio. The aliases are set up in the Site Administrator.
Your timeout could be related to several things including a PHP timeout when loading the package (that's what a load procedure does). Packages are also limited to 2GB.
Dave