• Hi Craig,

    Yes.*

    :{> Andy

    *There's more to it than that. It includes a discussion of when to use which configuration options and how to combine them so you can migrate SSIS packages from server-to-server (Dev-to-Prod, for example) and not have to open the package to edit connection strings for Connection Managers. I do not demonstrate the only way to do this, as there are several permutations. I demonstrate a way that, although complex, works in most places.

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics