Hi, Developed the SSIS package using the variables (such as source,destination servers,databases,usernames and passwords).Generated the .xml configuration file to set the variable values dynamically in production environment.Deployed the package on production server,placed the configuration file in C:\ and changed the all variable values accordingly. Trying to run the package using Execute Package Utility, it is not reading the variable values from the config file.It is showing the old values, which i used while developing the package. Any idea? Do I need to set any property value to use the updated config file values? Thanks, Rao

Does the package know it need to find the config file in C: ?Arthur My Blog

Seems to me since you are running the package with DTExec use /Conf setting to point it to the new location.Arthur My Blog

Yes,package know the configuration file(i.e Added by right clik and selecting package configuration) I can see the /Conf and configfile name in last page of the Execute Package Utility...

Could be that the configuration file cannot be accessed from C:\ i.e. no permissions. Try moving the configuration file to another location.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: MrWharty.wordpress.com

Fixed the problem.. Reason is,while deploying the package, at Package installer utility ->'Select Installation Folder' step folder path was given at ...\DTS\Packages\.. . I changed to C: and it created one new .config file. changed the variable values in configfile and it worked what i want. Thank you all for your replies.. regards, Rao