Microsoft SQL Server 2012 Integration Services (Developer Reference)

Microsoft SQL Server 2012 Integration Services (Developer Reference)

Microsoft SQL Server 2012 Integration Services (Developer Reference)

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you’ll handle complex data integration scenarios more efficiently—and acquire the skills you need to build comprehensive solutions. Discover how to:

  • Use SSIS to extract, transform, and load data from multiple data sources
  • Apply best practices to optimize package and project configuration and deployment
  • Manage security settings in the SSISDB catalog and control package access
  • Work with SSIS data quality features to profile, cleanse, and increase reliability
  • Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps
  • Load data incrementally to capture an easily consumable stream of insert, update, and delete activity

List Price: $ 59.99

Price: [wpramaprice asin=”0735665850″]

[wpramareviews asin=”0735665850″]

Related Products

3 comments

  1. 2 of 2 people found the following review helpful
    2.0 out of 5 stars
    “Noooo!”, July 16, 2014
    By 
    Dimitri Shvorob
    (REAL NAME)
      

    This review is from: Microsoft SQL Server 2012 Integration Services (Developer Reference) (Paperback)
    … is my measured response to the reviews entitled “Full coverage of the subject matter” and “A great reference book on SSIS 2012”. It is also my warning to those considering this book as an SSIS learning aid.

    You have to wonder what’s going on if the book gets around to building its first SSIS package in Chapter 7: if it were a book for beginners, Chapter 2 or 3 would be a more appropriate place, and if it were a book for intermediate or advanced SSIS users, this introductory material would not be needed at all. The beginner who persevered through Chapters 1-6, learning about the upgrade procedure and the new features of the 2012 release (revised syntax of XML-format SSIS package files, anyone?), gets to load a text file into a database – and then, without a single transformation explained, is asked to implement parent-child packages, and execute them with T-SQL (!) and C# (!!). With this, core SSIS training is over, and the book moves on to more advanced or niche topics like CDC, “fuzzy” transformations and DQS, administration and performance.

    It is only those more advanced topics, found in Part III, which can make this book worth a look. (The upgrade-and-new-features stuff of Chapters 3-5 can be found online). Although I did consider hiring an assassin to go after the author of Chapter 10 – when talking about SSIS 2012, it is very important to be clear about the differences between package deployment model and project deployment model, and that chapter fails this test like there’s no tomorrow – the problem is not really with the individual chapters, but with lopsided, incomplete nature of their sum.

    Dial M for “Microsoft Press, you sure dropped the ball with this one”.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  2. 5.0 out of 5 stars
    Good Resource for Upgrading to SSIS 2012, November 17, 2012
    By 
    R. Bower
    (REAL NAME)
      

    Verified Purchase(What’s this?)
    This review is from: Microsoft SQL Server 2012 Integration Services (Developer Reference) (Paperback)
    Our shop currently uses SQL Server 2005 and 2008 R2, and this book is a good bridge to the new version. Good highlights on what is new and how to use the new features.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

Leave a Reply

Your email address will not be published. Required fields are marked *