• Yes, that'll work if you want to run it interactively. If you want to automate it, you'll need to centralise using SSIS or similar.

    John