Due to a SQL server migration project (2005 => 2005), we will have to adapt more then 400 DTS packages, since we will have to use different paths for source and destination in the new environment.
I have opened some DTSX files in notepad, and it seems to be clear text in XML format...
I'm not a SQL server specialist, but i have a lot of scripting experience.
So my question is:
Could I use a vbscript to :
1. open all DTSX file (one by one),
2. replace old source and destination paths by the new source & dest paths
3. write to new DTSX files
4. import the new (altered) DTSX files in the new SQL server
Does somebody has experience with this? Which strings/tags will I have to replace?
I searched for half an hour in Google and could not find someone who already did this.