• I am by no means an expert, but from your explanation I'd suggest a simple SSIS package with data flow, which is called by a scheduled job.

    -------------------------------------------------
    Trainee DBA