Hi all, We had to change a column name in a database we are using. The IS packages that used that old column name of course fell over. Not wishing to reset them all up I simply replaced the old column name with the new one in all the XML files in the project Now this seems to have worked. But surely it cannot be that simple. Am I missing something ? Anyone ever done anything like this ? I know it is bad practice but it really was a needed change to accommodate a production change. Many thanks

No problem... dtsx is just xml. The only thing you can't change in the XML are Script Components and Tasks (they are compiled). You can also right click the package in the Solution Explorer and select View Code... Or even do a search and replace... (just make sure you have a backup) Although doing it on a production machine without testing could be a little risky... :-) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Thanks SSISJoost - Scripts in this instance are not a problem as they work on Recordset variables and don't care about the column names but I do take your point. Many thanks for replying.