Morning Guys, I have like 500 packages deployed under various sub folders in msdb. In each of these packages we have package configurations enabled. Package config type is XML config. It uses environment variable to locate the config file and then reads connection string from it. I want to update every deployed package to change the name of the environment variable configured in XML package configuration. Can someone please guide on this? Thanks, Pulkit Ojha Microsoft Business Intelligence Developer

In the management studio in the edit tab use replace property, Place all the packages in one folder then replace the variable name with old one, then redeploy to msdb. Keep in mind there should not be anything in the package with same name as old variable name. You have to analyse bit. Please propose as answer if it helps. Thanks Sumit

if you have .net experience then you could loop through all packages in the msdb and edit them... I once looped through the msdb to download them, but I think you could also edit them.. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter