Professional SQL Server 2005 Integration Servicesby Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson
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… See more details below
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.
and post it to your social network
Most Helpful Customer Reviews
See all customer reviews >
I bought this book on the strength of the lead author's previous book on DTS. I have to say I'm somewhat disappointed. SSIS has become a teriffically more complicated albeit more powerful tool than DTS. Unfortunately, the way Wrox has chosen to deal with this complexity is by 'throwing more authors' at the subject. There are some great individual sections but on the whole this doesn't make up for the book's short-comings. There are key pieces of information that are flat out 'missing' (like the ProtectionLevel property of a package). For myself, I buy a book like this to find out as quickly as possible 'how to use the product'. I'm not especially interested in 'Software Development Life Cycles: A Brief History' - one of several sections in this book that should have been cut.
I found the content to be well-founded for professionals looking to get into SQL 2005 Integration Services (SSIS) for the first time. There was a fair amount of mention of previous SQL 2000 DTS, which was, in large, unnecessary. However, the Wrox Press methods of explaining and then demonstrating were as solid as ever. You'll find the mini-projects to be helpful, whether you are reading through or actually performing them. All things considered, this is a strong reference in my library.