TFS and SSIS

Question

Hello All,

I am trying to implement version control system for SSIS (2008) using Team Foundation Server. The basic functions like checkin, checkout and Branching are working fine but merging doesn't seems to be perfect. Not all the conflicts are getting resolved when using the auto merge functions. when comparing two versions of a package, the comparison is not so clear as its showing everything in XML coding. Is there any way to see things as what they are actually? Is that possible to add a third party merge tool which compares without XML ?

Thanks in advance.

Thanks,

rdineshkumar

Answer 1

All,

This question is currently being addressed on the SSIS forum here: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/87207bfe-0baf-45a2-a6cc-12275c552985 so to avoid duplication of answers please hop over there to respond.

Regards
JT

---

ObjectStorageHelper<T> – A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 2

Merging package files in SSIS versions prior to 2012 is not possible in the majority of cases, definitely not a good idea to merge using any  merging utilities or even TFS. The reason is lineageIDs are different from package to package preventing a successful merge.

In SSIS 2012 they are gone and thus merging becomes more feasible.

---

Arthur My Blog