Summary

You now have a clearer picture of the Software Development Life Cycle of SSIS projects. In this chapter, you learned how to use the new Integrated Development Environment (IDE) to add SSIS projects to Microsoft Visual SourceSafe. You also learned how to do the following:

• Create a Team Project in Team System

• Add a SSIS project to the Team Project

• Manage and report project status

• Control the SSIS source code

Finally, you have more experience with code promotion — deploying an SSIS package from Development to an Integration Services server, as well as exporting a package to another Integration Services server.

You know more about software development methodologies and about how Team Foundation Server allows you to customize Team System to clearly reflect your methodology of choice. Team System is a fascinating framework! I encourage you to learn more about Team System and Team Foundation Server from the Professional Visual Studio 2005 Team System, by Jean-Luc David, et al. (Wiley, 2006), and the MSDN Team System Developer center (http://lab.msdn.microsoft.com/teamsystem).