We have multiple Data Services development environments to support a Project that is being worked on. After so many weeks we need to merge the code from these two Development areas so that we can promote them through the rest of our environments.
We were doing a manual merge where we would just open up the two jobs from the different environments and make the changes again evaluating
what needed updated/modified. As you can imagine this can be a painful process.
We have also tried exporting a job/data flow to a atl file and do a compare using a compare tool but that didn’t work as well as we would have hoped.
The best luck we have found so far is exporting to an xml file and merging that way. We have only just begun to try this though so we are
not to confident that we won’t run into problems this way as well. We did get one simple change to merge successfully but we lost the designer layout when we reimported the xml file.
So we are wondering if there is a standard way to do merges in Data Services or at least a best practice.