• You have numerous configuration management options in SSIS. Personally I like using XML Package Configuration files for this kind of work. When I deploy a package to 'dev' or am working locally I have the 'dev' configuration file in place containing the environment-specific configuration settings relevant to my dev environment. When I push the package to QA I also deploy the 'QA' configuration file with it which has the exact same structure as my 'dev' configuration file but with the values changed for QA. Note that while the data-values within the configuration file are different between dev and QA the XML structure is identical and the physical path to the file must be the same on all machines, e.g. if you point the SSIS package to D:\SSISConfig\MyPackageConfigurationFile.dtsConfig to get the config file in dev then the file must exist there on the QA machine as well.

    Understanding Integration Services Package Configurations

    Package Configurations

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato