Features
- Cover Type: Paperback with 720 pages
- Published by: Wrox January 31, 2006
- Written in: English
- ISBN 10 Number: 0764584359
- ISBN 13 Number: 978-0764584350
-
Book Dimensions:
9 x 7.3 x 1.6 inches
- Weighs: 1.3 pounds
Book Description
This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.
What you will learn from this book - Ways to quickly move and transform data
- How to configure every aspect of SSIS
- How to interface SSIS with web services and XML
- Techniques to scale the SSIS and make it more reliable
- How to migrate DTS packages to SSIS
- How to create your own custom tasks and user interfaces
- How to create an application that interfaces with SSIS to manage the environment
- A detailed usable case study for a complete ETL solution
Who this book is for This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills.
Wrox Professional guides are planned and written by working programmers to meet the real-world requirements of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Back Cover Copy
This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.
What you will learn from this book
- Ways to quickly move and transform data
- How to configure every aspect of SSIS
- How to interface SSIS with web services and XML
- Techniques to scale the SSIS and make it more reliable
- How to migrate DTS packages to SSIS
- How to create your own custom tasks and user interfaces
- How to create an application that interfaces with SSIS to manage the environment
- A detailed usable case study for a complete ETL solution
Who this book is for
This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills.
Wrox Professional guides are planned and written by working programmers to meet the real-world requirements of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Reader Reviews
While I share the enthusiasm of the other reviewers, I'm not entirely convinced that any of them have read far enough to give the book 5 stars. I have nearly ten years under my belt in BI, worked with SQL Server extensively, and not too shabby in the .NET department either; to be certain, SSIS 2005 is truly groundbreaking. However, the watchful readers will find a hurried book in their hands, one numerous typos and misleading information. For example, while I was able to figure out the nature of the strongly-typed properties of the incoming Row object for the Script Component example (Chapter 7) (you need to define the "Cleaned" ones yourself in the Script Transformation Editor to support the code for your Script Component), the book isn't completely clear and such information may not be so apparent to those new to the SSIS (or ETL) experience. Donald Farmer's book covering SSIS 2005 Scripting (the beta version) covers the Script Task and Script Component Transform Task better than Professional SQL Server 2005 Integration Services. Whilst I have focused on Chapter 7, I have found this pattern throughout the book. To be clear, I'm not terribly displeased with this book... it provides just enough coverage of the new product to get you going (with a welcome "under the hood" look at the SSIS engine) it's just that a 2nd Edition is required from WROX/WILEY to clean up its somewhat misleading content.
Comment | |
(Report this)
Search for books at
