How to dynamically set XML configuration path or SQL server configuration in SSIS

How to dynamically set XML configuration path or SQL server configuration in SSIS

Most commonly used configuration types are XML Configuration File and SQL Server Configuration.

One of most difficult part is set the configuration file path in prior to SQL Server 2012 version, I mean before introduce parameters. Prior versions are support two way to set configuration path direct and indirect.

Direct – Hard code the path as shown below

Indirect - Store a configuration in a Windows environment variable

Cheers!
Uma