Package Configurations

Configurations are mechanism for dynamically changing the properties of Objects and components at runtime.

Types Of Configurations

1. XML File Configuration
2. SqlServer Configuration
3. ParentPackage variable Configuration
4. Environment variable Configuration
5. Registry Entry Configuration

    Navigation:

    XML File Configuration:

      Step1: Right Click On Control Flow-->Click On 'Package Configuration'

      Step2: Select the Check box 'EnablePackageConfiguration'

      Step3: Click on ADD -->then NEXT

      Step4: Select the configuration Type as 'XML File Configuration File' from the dropdown list.

      Step5: Specify the Configuration file location by clicking on BROWSE

      Step6: click on SAVE-->NEXT

      Step7: Minimise Variables,Connection Manager,Properties,Executable on object

                Then Expand variables-fileloc-Properties select the checkbox 'Value'

                minimise fileloc and select value in Source location

                minimise Source location

      Step8: Then Expand Connection Managers--localhost Target select the property connection  

                 string 

     Step9: Then click NEXT and Type the configuration file name

     Step10: click on finish