SQL Server 2005 is the flagship relational database product from Microsoft. Given the many improvements in SQL Server 2005 it is likely that many existing users of SQL Server 2000 will upgrade. Many who upgrade to SQL Server 2005 can be expected to need SQL Server 2005 Integration Services (SSIS) functionality. Many companies hold data in varied formats and routinely need to transform data from one format to another, as well as to move data from one location or application to another. Those types of business needs are the reason that SSIS exists and, potentially, has such a healthy market.…mehr
SQL Server 2005 is the flagship relational database product from Microsoft. Given the many improvements in SQL Server 2005 it is likely that many existing users of SQL Server 2000 will upgrade. Many who upgrade to SQL Server 2005 can be expected to need SQL Server 2005 Integration Services (SSIS) functionality. Many companies hold data in varied formats and routinely need to transform data from one format to another, as well as to move data from one location or application to another. Those types of business needs are the reason that SSIS exists and, potentially, has such a healthy market. This is possibly the hottest area in SQL Server 2005, itself a major hot topic because of its improvements over previous editions of the technology. The audience is potentially large, because it consists of all users of SQL Server 2005 who want to extract, transform, and load data. In essence, almost all business users will have a need for the functionality of SSIS. Pro SQL Server 2005 Integration Services is based on the author's unique experience and feedback from real-world users, which gives a clarity of voice and a breadth of coverage that other books cannot match. TOC:Introducing SSIS.- Using the Business Intelligence Design Studio.- Creating Simple SSIS Projects.- A Closer Look at the BIDS Interface.- A Closer Look at the Toolboxes.- A Closer Look at Data Sources.- A Closer Look at SSIS Pipelines.- A Closer Look at Transformations.- A Closer Look at Data Destinations.- Event Handlers in SSIS.- Controlling SSIS using WMI.- Using XML As a Data Source.- Merging Data From Several Sources.- Cleaning and Standardizing Data.- Using Fuzzy Logic to clean Data.- Populating and Refreshing a Data Warehouse.- Debugging SSIS Projects.- Deploying SSIS.- Migrating SQL Server 2000 DTS Packages.- Using SSIS to Automate Tasks.- Handling Errors.- Schedule-Driven Packages.- SSIS Package Management.- Managing Security for SSIS.- Using SSIS from the Command Line.- Using SSIS Functions and Expressions.- Extending Maintenance Plans.- Documenting Integration Services Packages.- The SSIS Object Model.- Glossary.
Andrew Watt has written SQL Server 2005 for Dummies (Wiley/IDG, January 2006) and Beginning Regular Expressions (Wiley/Wrox, February 2005). He has also co-written a number of other books, including books on XML, XSL, and RSS. Andrew has been an independent consultant and author for six years. He is a SQL Server MVP and has set up www.SQLIAR.com, which reflects the IAR (Integrate, Analyze, Report) paradigm in SQL Server 2005 Business Intelligence.
