Among the new features in SQL Server 2005 is SQL Server Integration Services, or SSIS. This "point-and-click" database management tool now serves as the SQL Server's main extraction, transformation and loading tool, having replaced Data Transformation Services, or DTS.
Professional SQL Server 2005 Integration Services from Wrox Press is aimed at both developers and database administrators who will programming custom .NET code. The book's 10 authors cover processes such as configuring and scaling SSIS, creating SSIS interfaces with Web services and XML, migrating DTS to SSIS and creating custom tasks and UIs.
In Chapter 18, "SSIS Software Development Life Cycle," the authors describe Microsoft's source control products for SSIS. Visual SourceSafe 2005 has been upgraded for better stability and access, while the new Team System and Team Foundation Server offer collaborative services and integrated functionality. The chapter also covers the project portal within SharePoint Portal Services and offers guidance on deploying and testing projects.
MORE: Click here to read Chapter 14 of this book, " Programming and Extending SSIS."
Excerpted from the Wrox book, Professional SQL Server 2005 Integration Services (ISBN 0-7645-8435-9)by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji and Mike Murphy.
Copyright © 2006. Published by John Wiley and Sons Inc., and available at your favorite book seller. Reprinted with permission.