Create the environment Variable for package Configuration.(Window 7)

1.Create Package Configuration(XML Configuration File)for Connection String using Package Configuration Wizard:

2.Export only Connection String Properties in to the configuration File:

3.Save the Config File.
4.Create the environment variable setting in the Package."Indirect XML configuration File"

"Config_Env_variable" is the "Environment Variable" which we create in step no 5.
5.To Set the  Environment Variable for the Package Configuration :Follow the Below Step

Create a system Variable ,here it is called "TFODWConfiguration" and the variable value contain the Configuration File Path ,here the File name is "TFODWConfiguration.dtsConfig".
Config File contain the Connection String Information ,which we generate through Wizard.




##############################################################
2.Configure package using the SQL Server(using Configuration table)