Source Code Control

Development of solutions based on SSIS might require you to write a lot of packages, and you might also find yourself working in teams with other people. In any professional development environment, the ability to avoid any loss of any single line of code—in this case, XML code, because packages are really XML files—should be guaranteed.

In addition, the development environment should allow you to work on the same solution that your other colleagues are working on, without creating overlapping changes that might cause you to lose your work. This can happen, for example, if you and a colleague work on the same package simultaneously. The last person to save the package will overwrite the other’s changes.

As a last point, the development ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.