Sorry if this is redundant, I thought I saw an answer to my question in a previous post but cant find it now.
We have a bunch of pdi with an old server name his1a, we need them to be changed to his1c, I know about creating alias in connection manager but we want to actually change the settings in each of the trends,values datasets etc, without having to do it one at a time.
Is there a find replace feature like excel? or a tool? or vba sample to do this?
Again I apoligize if this thread is already started somewhere else
Thanks in advance