There are two keys to a successful ETL solution: using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements. With SQL Server 2014 Integration Services, half the battle is won. The out-of-the-box features provide the depth and breadth of functionality and flexibility needed to create scalable solutions. Even more, the usability and rapid learning curve reduce solution development time.
The second ingredient is correct ETL architecture and design. When considerable effort is spent testing scenarios and proving out designs, valuable testing, implementation, and deployment time is lost. This book fills that gap.
"Professional SQL Server 2014 Integration Services" will, of course, fully cover the new features of the 2014 product release, expected in early 2014. The book will be about 20% revised, reflecting changes in how the product looks and works. In addition to technical updates and additions, the authors will add a new set of best practices for effective use of SSIS; more case studies, and tutorial examples to illustrate advanced concepts and techniques.
Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com, JumpstartTV.com, and is on the Principal Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for many industry magazines and sites. He has co-authored and authored more than 9 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. --from the author's website
Librarian Note: There is more than one author in the GoodReads database with this name.
Great book by the great Brian Knight. I liked it more than I thought I would. Regardless of its length, I didn't get the feeling of boredom in any part. The only thing to note here is that lots of practices and steps need to be encapsulated into bullet/numeric lists. That's all!
A very good book about SSIS and a great improvement compared to the previous edition of the book (about SSIS 2012). I tried hard to criticize this book but failed. This book is very well written and definitely is worth is money.
Would recommend this to anyone familiar with the basics of SSIS that wants to become proficient in this technology.