Copy Config File and Set Environment Variable

1. Copy BBDW_ETL_Config.dtsConfig to BBDW_ETL_Config.{your name}.dtsConfig. In other words create a personal copy of BBDW_ETL_Config.dtsConfig with a different name.

   There is a copy of BBDW_ETL_Config.dtsConfig is located in ..Datamarts\BBDW\SSIS. But, after a deployment, the utility creates a version in your SQL Server folder. For example:

   C:\Program Files\Microsoft SQL Server\100\DTS\Packages\BBETL\Shelby_RPT_BBDW

   Most of the settings in that version should be specific to your installation. Since you will probably have a local installation set up for your development environment, most of the settings should be correct.

2. From your machine's system properties, create an environment variable named BBDW_ETL_CONFIG_PATH.

   1. From your desktop or Start menu, right-click Computer or My Computer.

   2. Click Properties.

   3. Click Advanced system settings. The System Properties screen appears.

   4. Click Environment Variables.

   5. Click New.

   6. In Variable name, enter BBDW_ETL_CONFIG_PATH.

   7. In Variable value, enter the path to your personal .dtsconfig file such as C:\Program Files\Blackbaud\bbappfx\MSBuild\Datamarts\BBDW\SSIS\BBDW_ETL_CONFIG.Personal.dtsConfig.

   8. Click OK for each screen.

      When you run the deployment utility, the utility copies the SSIS packages and changes the configuration of the packages to point to a new environment variable and a different config file. The development config file is independent of the deployment config.