 |
Professional SQL Server 2005 Integration Services
Read an excerpt:
Chapter 1: Welcome to SQL Server Integration Services
Excerpt provided courtesy of John Wiley & Sons Inc. Copyright © John Wiley & Sons Inc. Written permission from the publisher is required for any use of this material.
|
Customer Reviews: 2 Average Customer Rating:   Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Professional SQL Server 2005 Reporting Services; Paul Turley, et al, $24.95, 38% Off!
- Expert SQL Server 2005 Integration Services; Brian Knight, et al, $30.50, 39% Off!
- Microsoft SQL Server 2005 Unleashed (Stock Expected July 8th); Ray Rankins, et al, $32.95, 45% Off!
- Professional SQL Server 2005 Performance Tuning; Steven Wort, et al, $30.50, 39% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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 needs 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.
Table of Contents
Acknowledgments.
Foreword.
Introduction.
Who This Book Is For.
How This Book Is Structured.
What You Need to Use This Book.
Conventions.
Source Code.
Errata.
p2p.wrox.com.
Chapter 1: Welcome to SQL Server Integration Services.
Chapter 2: The SSIS Tools.
Chapter 3: SSIS Tasks.
Chapter 4: Containers and Data Flow.
Chapter 5: Creating an End-to-End Package.
Chapter 6: Advanced Tasks and Transforms.
Chapter 7: Scripting in SSIS.
Chapter 8: Accessing Heterogeneous Data.
Chapter 9: Reliability and Scalability.
Chapter 10: Understanding the Integration Services Engine.
Chapter 11: Applying the Integration Services Engine.
Chapter 12: DTS 2000 Migration and Metadata Management.
Chapter 13: Error and Event Handling.
Chapter 14: Programming and Extending SSIS.
Chapter 15: Adding a User Interface to Your Component.
Chapter 16: External Management and WMI Task Implementation.
Chapter 17: Using SSIS with External Applications.
Chapter 18: SSIS Software Development Life Cycle.
Chapter 19: Case Study: A Programmatic Example.
Index.
About the Authors
Brian Knight, SQL Server MVP, MCSE, MCDBA, is the cofounder of SQLServerCentral.com
and was recently on the Board of Directors for the Professional Association
for SQL Server (PASS). He runs the local SQL Server users group in Jacksonville,
Florida (JSSUG). Brian is a contributing columnist for SQL Server Standard and
also maintains a weekly column for the database Web site SQLServerCentral.com.
He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and
coauthor of Professional SQL Server DTS and Professional SQL Server 2005 SSIS
(Wiley Publishing). Brian has spoken at such conferences as PASS, SQL Connections,
and TechEd. His blog can be found at www.whiteknighttechnology.com.
Allan Mitchell is joint owner of a UK-based consultancy, Konesans, specializing
in ETL implementation and design. He is currently working on a project for one
of the UK’s leading investment banks doing country credit risk profiling
as well as designing custom SSIS components for clients.
Darren Green is the joint owner of Konesans, a UK-based consultancy specializing
in SQL Server, and of course DTS and SSIS solutions. Having managed a variety
of database systems from version 6.5 onwards, he has extensive experience in
many aspects of SQL Server. He also manages the resource sites SQLDTS.com and
SQLIS.com, as well as being a Microsoft MVP.
Douglas Hinson, MCP splits his time between database and software development
as a Senior Architect for Hinson & Associates Consulting in Jacksonville,
Florida. Douglas specializes in conceptualizing and building insurance back-end
solutions for payroll deduction, billing, payment, and claims processing operations
in a multitude of development environments. He also has experience developing
logistics and postal service applications.
Kathi Kellenberger is a database administrator at Bryan Cave LLP, an international
law firm headquartered in St. Louis, Missouri. She fell in love with computers
the first time she used a Radio Shack TRS-80, many years ago while in college.
Too late to change majors, she spent 16 years in a health care field before
switching careers. She lives in Edwardsville, Illinois, with her husband, Dennis,
college-age son, Andy, and many pets. Her grown-up daughter, Denise, lives nearby.
When she’s not working or writing articles for SQLServerCentral.com, you’ll
find her spending time with her wonderful sisters, hiking, cycling, or singing
at the local karaoke bar.
Andy Leonard is a SQL Server DBA, MCSD, and engineer who lives in Jacksonville,
Florida. Andy manages a SQL Server DBA Team. He has a passion for developing
enterprise solutions of all types and a fondness for business intelligence solutions
in industrial enterprises. Learn more at www.andyleonard.net and reach Andy
at andy@andyleonard.net.
Erik Veerman is a mentor with Solid Quality Learning and is based out of Atlanta,
Georgia. Erik has been developing Microsoft-based Business Intelligence and
ETL-focused solutions since the first release of DTS and OLAP Server in SQL
Server 7.0, working with a wide range of customers and industries. His industry
recognition includes Microsoft’s Worldwide BI Solution of the Year and
SQL Server Magazine’s Innovator Cup winner. Erik led the ETL architecture
and design for the first production implementation of Integration Services and
participated in developing ETL standards and best practices for Integration
Services through Microsoft’s SQL Server 2005 reference initiative, Project
REAL.
Jason Gerard is President of Object Future Consulting, Inc., a software development
and mentoring company located in Jacksonville, Florida (www.objectfuture.com).
Jason is an expert with .NET and J2EE technologies and has developed enterprise
applications for the health care, financial, and insurance industries. When
not developing enterprise solutions, Jason spends as much time as possible with
his wife Sandy, son Jakob, and Tracker, his extremely lazy beagle.
Haidong Ji, MCSD and MCDBA, is a Senior Database Administrator in Chicago,
Illinois. He manages enterprise SQL Server systems, along with some Oracle and
MySQL systems on Unix and Linux. He has worked extensively with DTS 2000. He
was a developer prior to his current role, focusing on Visual Basic, COM and
COM+, and SQL Server. He is a regular columnist for SQLServerCentral.com, a
popular and well-known portal for SQL Server.
Mike Murphy is a .NET developer, MCSD, and in a former life an automated control
systems engineer currently living in Jacksonville, Florida. Mike enjoys keeping
pace with the latest advances in computer technology, meeting with colleagues
at Jacksonville Developer User Group meetings (www.jaxdug.com) and, when time
allows, flying R/C Helicopters. To contact Mike, e-mail him at mike@murphysgeekdom.com
or visit www.murphysgeekdom.com.
Customer Reviews
Customer Reviews: 2 Average Customer Rating: Aug 23, 2007 w dismukes from Katy, Texas
Pretty Good
I am about 1/3 through the Professional SQL Server 2005 Integration Services book. It was worth buying. I don't view this as a Step-By-Step type book. You need a little SSIS background first. A background in DTS will not necessarily prepare you for SSIS. Watching the videos on the LearnIntegrationServices,com web site FIRST is definitely the way to go. The major negative that I have thus far is that it is somewhat difficult to follow when trying to complete the example packages. More step1, step2, etc. would have been helpful. However, I have been able to make all of the examples work. Sometimes that is a major accomplishment with these type books. Also, be sure to view the corrections errata on the Wrox website.
May 1, 2006 Mike B. from Nashua, NH - U.S. of A.
A Little Disappointing But Still Good
Like many folks, I'm making the transition from DTS to SSIS - and I bought this book on the strength of the authors' previous book on DTS. This book isn't quite as good - and I'm not sure why. Maybe it's the organization - it just does't seem to flow as well from one chapter to the next. You really have to get through quite a lot of preliminaries before you hit the meat and potatoes of SSIS. Nevertheless, there are great individual sections and examples - especially on the new XML capabilities. I would still buy the book - but I'll probably be on the look out for another one on this same topic.
|
|
