• I would recommend going with straight up Package parameters to set these. If you are on 2012 and greater, consider using SSIS environments. Here's a walk-through. I think it's pretty close to what you are asking for.

    https://www.simple-talk.com/sql/ssis/ssis-2012-projects-deployment-configurations-and-monitoring/

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden