Defining and reading Configuration file

Defining and reading Configuration file
First step of the SSIS package is to execute Framework package to read all the configurations from the package configuration file and assign to variables which were defined on package level. 
1.1 Configuration file

Configuration file structure
<? Xml version="1.0" encoding="utf-8"?>     <Configurations> <SSIS_FrameWork_Config_Reader>    <VariableCollection>          <Your Package name>                 </ Your Package name > </VariableCollection> </SSIS_FrameWork_Config_Reader> < Package name >Define all your variables required for your package </ Packagename></ Configurations>

1.2 Configure and execute common Framework package from the main packages

Step1: Drag and drop execute process task component on the control flow

Step2: Configure the execute process task properties as below.