O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required