windows_mss (8/1/2014)
Hi,I have done with the SSIS Package and it's working as expected in my local machine, I have one problem is that how I can give my XML configuration file path as input to my SSIS package dynamically during runtime, because in local Iām having in C:\Extract\Config.dtsconfig. But in higher environment the path will be different. Is there any way to set this configuration file path?
When I tried with .\Config.dtsconfig in Package Configuration Wizard on the cursor focusing out it's giving the pull path again.
Kindly Guide me.
First a quick question, which version are you on?
The config is initialized before the execution so no luck there. That means that unless you dynamically create/modify the package, it cannot be done. A workaround would be storing the config in a database and use the likes of sys variables to choose which config to use.
š