svnssis

SSIS Packages Version Controlling


Is there a good way of version controlling SSIS packages.

Any suggestions / ideas please

thanks


Solution

  • I would recommend the Smart Diff feature in BIDS Helper. This is very useful for comparing two versions of a package to see what has changed.

    The standard Visual Studio compare functionality is not very helpful in this regard. BIDS Helper does a much better job because it prepares canonical versions of both files (this includes splitting long lines of XML) before doing the comparison.