I have a SSIS 2008 R2 package with design time default properties set for my dev environment. How I use the /SET option to change the location of the ConfigFile as per the Microsoft documentation. I would appreciate an example. Thanks

As per BOL, You can use the /Set option to change the location from which package configurations are loaded. However, you cannot use the /Set option to override a value that was specified by a configuration at design time /SET \package\DataFlowTask.Variables[User::MyVariable].Value;newValue. The syntax is similar in all versions but there are behavioral changes to application of configruations in different versions. Dtexec option and usage Behavior in SQL Server Integration Services 2005 Behavior in SQL Server Integration Services 2008 Using the /Set option to change a property value that is also set by a design-time configuration Succeeds. The new value is not overwritten because the utility does not reload design-time configurations after it applies the run-time options. Has no effect. The new value is overwritten when the utility reloads the design-time configurations after it applies the run-time options. Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

I have a SSIS 2008 R2 package with design time default properties set for my dev environment. How I use the /SET option to change the location of the ConfigFile as per the Microsoft documentation. I would appreciate an example. Thanks I advise you to use /CONF rather than /SET. /CONF allows you to pass a config file location to the package.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me