SQL Server 2012 Integration Services Design Patterns and over 1.5 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Share your own customer images
Search inside this book
Start reading SQL Server 2012 Integration Services Design Patterns on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL Server 2012 Integration Services Design Patterns [Paperback]

Andy Leonard (Author), Matt Masson (Author), Tim Mitchell (Author), Jessica Moss (Author), Michelle Ufford (Author)
3.0 out of 5 stars  See all reviews (1 customer review)
RRP: £39.99
Price: £33.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £6.00 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want delivery by Friday, 24 May? Choose Express delivery at checkout. See Details

Formats

 Amazon Price New from Used from
Kindle Edition £15.28   -- --
Paperback £33.99   -- --
Books Trade-In
Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more.

Book Description

Publication Date: 3 Oct 2012 | ISBN-10: 1430237716 | ISBN-13: 978-1430237716 | Edition: New

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.

SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services.

  • Takes you through solutions to several common data integration challenges
  • Demonstrates new features in SQL Server 2012 Integration Services
  • Teaches SSIS using practical examples

What you’ll learn

  • Load data from flat file formats
  • Explore patterns for executing SSIS packages
  • Discover a pattern for loading XML data
  • Migrate SSIS packages through your application lifecycle without editing connections
  • Take advantage of SSIS 2012 Dependency Services
  • Build an SSIS Framework to support your application needs

Who this book is for

SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It’s for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It’s an excellent choice for business intelligence and data warehouse developers.

Table of Contents

  1. Metadata Collection
  2. Execution Operations
  3. Scripting
  4. SQL Server Source Patterns
  5. Data Cleansing
  6. DB2 Source
  7. Flat File Source Patterns
  8. Parallel Data Warehouse
  9. XML
  10. Expression Language Patterns
  11. Data Warehouse
  12. Logging
  13. Slowly Changing Dimensions
  14. Loading the Cloud
  15. Reporting
  16. Parent-Child Patterns
  17. BIML
  18. Configuration
  19. Deployment
  20. Estimating ETL Projects

Frequently Bought Together

SQL Server 2012 Integration Services Design Patterns + Professional Microsoft SQL Server 2012 Integration Services
Price For Both: £55.74

Buy the selected items together

Product details

More About the Authors

Discover books, learn about writers, and more.
Jessica M. Moss
Matt Masson
Andy Leonard
Tim Mitchell
Michelle Ufford

Product Description

About the Author

Andy Leonard is an SSIS trainer and consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, SQL Server "Most Valuable Professional", SQLBlog.com blogger, and engineer. He is co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes web application architecture and development, Visual Basic, ASP, SQL Server Integration Services (SSIS), and data warehouse development using SQL Server 2000, 2005 and 2008.
Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

5 star
0
4 star
0
3 star
1
2 star
0
1 star
0
3.0 out of 5 stars
1 review
3.0 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
3.0 out of 5 stars High expectations followed by... Big disappointment 15 Oct 2012
By Eric Le Bouffon
Format:Paperback|Amazon Verified Purchase
I had pre-ordered this book because I was extremely interested by the idea of "Design Patterns" within an SSIS environment.

I must say I am very disappointed by the end product.
I am still not clear whether the book is an introduction to the new features in SSIS 2012 or whether it is about Design Patterns.
It seems to float from chapter to chapter somewhere in between.

I found the early chapters extremely poor.

It started well with an interesting chapter 1 about how to collect various data from several servers.
The Pattern was clearly introduced so that I had a good idea before diving in the details.
It was easy to read and instructive. Job well done.

Then came chapter 2...
I might be slightly daft but it is still not clear to me where the pattern is supposed to be... or what this was supposed to achieve.
It seems to assume knowledge of the new mode of Deployment/Execution offered by SQL 2012 and does not explain why we need to improve on it...
What's wrong with firing SSIS Packages from SQL Server Agent? No idea...

So I read about 40 pages of detailed stored procedure code with no idea what it was trying to achieve.
If you are patient enough, you will find the required explanations about the new deployment and execution tools in chapters 18 & 19... but I did not have the courage to re-read chapter 2 to see if it made more sense afterwards.

I found this lack of "Design Pattern" up to and including chapter 6.

After that, it becomes more interesting but still I regret, in many instances (not all chapters), the lack of an overall pattern description before diving in the details.
This forces you to read an entire chapter before knowing whether it is actually useful to you.

Overal, I did learn a few things as I am not an SSIS "expert" (hence the 3 stars) but I found the book not up to its title.

To me, a better example of "Design Pattern" book is "Expert Cube Development with Microsoft SQL Server 2008 Analyses Services"

I am not sure I would recommend that (expensive) book.
Comment | 
Was this review helpful to you?
Yes
No
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.2 out of 5 stars  6 reviews
3 of 3 people found the following review helpful
3.0 out of 5 stars Not what I expected 22 Feb 2013
By Brian Alan Carlson - Published on Amazon.com
Format:Paperback|Amazon Verified Purchase
What I have read of this book was well written and clear. I have liked books by Andy Leonard in the past, but I was disappointed at the level of the content in this one. It is written more for beginners and the title let me to think it would be at a deeper, more theoretical level. As a seasoned SSIS developer, I didn't find much of the content useful. About the only section that presented new material to me was DQS. Even that section did not add much to what I read on the microsoft website before this book came out.
7 of 9 people found the following review helpful
4.0 out of 5 stars Straight to the point. Problem. Solution - Excellent resource for ETL developers. 18 Sep 2012
By SamV - Published on Amazon.com
Format:Paperback
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly talented people we are talking about. Andy is constantly teaching SSIS patterns in his training classes and articles. Matt, for me, is the face of SSIS team at Microsoft. Same goes to other authors, they are common appearances in forums and community events helping people learn SSIS.

Within a few hours of reading this book, it stood out that none of the authors were trying to impress by showing what they all know in SSIS. Instead, they focused on describing solutions and patterns in a great detail (exactly why i paid for).

Each chapter is a collection of solutions and best practices to common data integration problems. For loading flat files go to chapter 7, for data warehouse patterns go to chapter 11. Each solution is written in detail with lots of pictures and step by step instructions. You could have the book open at work and follow through each step to solve a problem without running into any issues.

It is fun to read as well. I smiled when page 30 said VCR play button (referring to the debug button).Literature in the book is plain, clear, and casually written. It was like reading a blog post - simple and refreshing.

If you're on a mission to learn everything about SSIS, this book alone won't probably cut it for you. This isn't a know-all-SSIS book. Authors didn't hide this fact either. Cover of the book says "Improve your efficiency as a data integration developer". This focuses on patterns to data integration problems. If your job involves moving data using SSIS, this is a must have.

SSIS 2012 Design Patterns teaches building faster, efficient, and reusable packages for your data integration needs.

I'm @SamuelVanga on Twitter.
2 of 2 people found the following review helpful
4.0 out of 5 stars Great discussion about pro and cons 3 Nov 2012
By Jo Inge Stubbe - Published on Amazon.com
Format:Kindle Edition|Amazon Verified Purchase
Give ac lot of examples with pro and cons for each practice. Loveed the blog style it's written, easy and interesting
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

There's a problem loading this menu at the moment.

Learn more about Amazon Prime.

    Your Shopping Basket is empty.

    Give it purpose -- fill it with books, DVDs, clothes, electronics and more.

    If you already have an account, sign in.

    There's a problem previewing your shopping basket at the moment.

    Check your Internet connection and go to your cart, or try again.

    View Shopping Basket (0 items)

      Customer Discussions

      This product's forum
      Discussion Replies Latest Post
      No discussions yet

      Ask questions, Share opinions, Gain insight
      Start a new discussion
      Topic:
      First post:
      Prompts for sign-in
       

      Search Customer Discussions
      Search all Amazon discussions
         

      Listmania!

      Create a Listmania! list

      Look for similar items by category

      Feedback


      Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges