Book description
All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL).
Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.
Table of contents
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- Foreword
- About the Author
- Acknowledgments
- We Want to Hear from You!
- PART I. Getting Started
- PART II. Integration Services Basics and Concepts
- PART III. Control Flow Services
- PART IV. Management Services
- PART V. The Data Flow Task
- PART VI. Programming Integration Services
- Appendix A. Error, Warning, and Information Events
- Appendix B. Expression Evaluator Reference Sheet
- Index
Product information
- Title: Microsoft SQL Server 2005 Integration Services
- Author(s):
- Release date: July 2006
- Publisher(s): Sams
- ISBN: 0672327813
You might also like
book
Practical Guide to using SQL in Oracle
Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic …
book
Oracle Business Intelligence 11g Developers Guide
Master Oracle Business Intelligence 11 g Reports and Dashboards Deliver meaningful business information to users anytime, …
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …
book
Professional Microsoft SQL Server 2014 Integration Services
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL …