Hi all, i exported a package from develpoement , and did some modification in package ...now i want to deploy it into prod...it has 2 config files..in dev they are in D drive so path is like D:/... now in production those configuration files are in G drive...so do i need to change path in package/.....or is there any way to map them.. please let me know.. Thanks Jyo

Hi, There are a number of ways of achieving this. Consider indirect Configurations or tell the package where the config file resides using the /CONF option of dtexec.exe (I discuss the use of /CONF in my whitepaper Best Practices for Integration Services Configurations). Regards Jamiehttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Thanks Jamie, Actually my problem got soloved temporarily...i just copied my packages to DEV box and make changes and then deployed it...For permanat solution i will work on your solution.