An in–depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real–world experience that have transpired since the previous edition was published. Details the newest features of the 2012 SISS product release, which is the most significant release since 2005 Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.
Professional Microsoft SQL Server 2012 Integration Services
and over 1.5 million other books are available for Amazon Kindle . Learn more
| |||||||||||||||
 Trade In this Item for up to £7.66
Trade in Professional Microsoft SQL Server 2012 Integration Services for an Amazon.co.uk gift card of up to £7.66, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
|
Book Description
Frequently Bought Together
Product details
Would you like to update product info or give feedback on images?
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
From the Back Cover
Practical solutions and best practices for getting the most out of Microsoft SQL Server Integration Services The 2012 release of Microsoft SQL Server Integration Services (SSIS) offers significant new and enhanced features that greatly expand the capabilities of this product—but only if you know how to exploit them effectively. This book shows you how. It not only covers the latest features of the 2012 product release, it teaches you best practices for using them effectively. Each chapter includes helpful case studies and tutorial examples—all based on years of the expert authors′ real–world experience—to better illustrate concepts and techniques. Professional Microsoft SQL Server 2012 Integration Services: Explains how to extract, transform, and load (ETL) data with SSIS Covers each of the many SSIS tasks and Data Flow components Teaches you the most effective techniques for performance tuning SSIS Covers advanced techniques for data cleansing and incremental loads Shows how to load a data warehouse using built–in components in SSIS Covers best practices for manageability and scalability Wrox Professional guides are written by working developers to address everyday needs. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. wrox.com Programmer Forums Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world. Code Downloads Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use. Read More Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
About the Author
Brian Knight is the founder of Pragmatic Works and co–founder of SQLServerCentral.com and JumpstartTV.com. Erik Veerman is a consultant, author, trainer, and a mentor with SolidQ. His award–winning industry recognition includes Microsoft′s BI Solution of the Year and SQL Server Magazine′s Innovator Cup. Jessica M. Moss is a well–known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries. Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. He has co–authored several business intelligence books and regularly speaks at SQL events. Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software.
Inside This Book
(Learn More)
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
4.2 out of 5 stars
8 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars
A must have book for SSIS developers
20 Aug 2012
By ajitk
- Published on Amazon.com
Format:Paperback
This book explains each SSIS tools in detail with plenty of code samples which help to jump-start for newbies. Initially, it starts with slow pace but covers more advanced topics in later chapters such as "Accessing Heterogeneous Data", "SSIS Extension and Administration", "Integration with WMI and External Applications" etc. It provides the real practical experience while working with programmatic examples. I would recommend this as a great reference book even for expert SSIS developers.
5 of 6 people found the following review helpful
1.0 out of 5 stars
Tiny Screenshots and Lots of Typos
3 Mar 2013
By JShew
- Published on Amazon.com
Format:Paperback|Amazon Verified Purchase
I am a SQL Server database administrator, and I have worked with SQL Server for more than 15 years. Many years ago, I worked with DTS (Data Transformation Services) in SQL 2000, and I have worked briefly with SSIS (SQL Server Integration Services) 2008 R2. I purchased this book because I recognized some of the authors' names, and I had hoped the book would quickly bring me up-to-speed with SSIS 2012. However, I am disappointed with the book.
Unfortunately, the chapter layout did not work well for me. The first seven chapters (i.e., the first 231 pages) contain lots of "stub" code, but I don't recall any end-to-end examples. Chapter 8 (aptly named, "Creating an End-to-End Package") is the first complete tutorial for creating a useful package. However, the entire book is littered with typos. (No, I am not exaggerating here.) A tutorial object will be called one thing when you are asked to create it or rename it, and a later screenshot will display the same object with a different name, or a later reference on the next page will use a different name. And, subtle steps in the examples are skipped. Some of the book's content is out of order. For example, SSIS catalog logging is discussed on page 582, which is 166 pages before the creation of an SSIS catalog. You cannot work through this book from beginning to end. You have to use the index to hop around.
Virtually all of the screenshots are tiny. Often, a screenshot is roughly only 2 inches by 2 inches in size, and two screenshots are often placed side by side on the same page. I used a magnifying glass many times to decipher the screenshots, although I have "20 20" corrected vision. Fortunately, the print quality is good enough for a magnifying glass to work.
I suppose this is a useful book (if you don't mind scratching your head a lot to figure out how to make the examples work), but it was much harder to use than I anticipated (mostly because of the tiny screenshots and typos). The most useful chapters for me were 6, 8, 12, 16, and 17. Chapter 22 (Administering SSIS), one of the reasons I bought the book, is an absolute mess.
Unfortunately, the chapter layout did not work well for me. The first seven chapters (i.e., the first 231 pages) contain lots of "stub" code, but I don't recall any end-to-end examples. Chapter 8 (aptly named, "Creating an End-to-End Package") is the first complete tutorial for creating a useful package. However, the entire book is littered with typos. (No, I am not exaggerating here.) A tutorial object will be called one thing when you are asked to create it or rename it, and a later screenshot will display the same object with a different name, or a later reference on the next page will use a different name. And, subtle steps in the examples are skipped. Some of the book's content is out of order. For example, SSIS catalog logging is discussed on page 582, which is 166 pages before the creation of an SSIS catalog. You cannot work through this book from beginning to end. You have to use the index to hop around.
Virtually all of the screenshots are tiny. Often, a screenshot is roughly only 2 inches by 2 inches in size, and two screenshots are often placed side by side on the same page. I used a magnifying glass many times to decipher the screenshots, although I have "20 20" corrected vision. Fortunately, the print quality is good enough for a magnifying glass to work.
I suppose this is a useful book (if you don't mind scratching your head a lot to figure out how to make the examples work), but it was much harder to use than I anticipated (mostly because of the tiny screenshots and typos). The most useful chapters for me were 6, 8, 12, 16, and 17. Chapter 22 (Administering SSIS), one of the reasons I bought the book, is an absolute mess.
2 of 2 people found the following review helpful
5.0 out of 5 stars
A book that works
20 Aug 2012
By Lawrence Matias
- Published on Amazon.com
Format:Paperback
To maintain continuity of the lessons the sample database can be downloaded from Wrox website. This is very helpful and a time saver because you do not need to find the correct version of the database to match the book. I also wish that I had this kind of caliber of a book when I first started with SQL 2000. This book has it all. It shows you all the necessary entry points and pitfalls that you will encounter during the process. The steps in the lessons are clear and match SQL 2012 UI accurately. It is not like working with some books that the version that the book was based on, was not the production version. This has been a time saver. Overall this book is priceless.
›
Go to Amazon.com to see all 8 reviews
4.2 out of 5 stars
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
