I have created a few packages which uses shared 2 data sources called source
and desitination. When i change the server in the datasource file
manually\programatically, it is not reflecting in all the packages. Ideally
all the packages should refer to this shared datasource,but i found out that
the server name is hardcoded in each and every package which destroyes the
concept of shared data sources in SSIS packages.How ever if i change the
server name in the data source from the SSIS environment itself then all
packages using the shared datasource are updated.Is there a work around for
this apart from changing the server in every package.