Microsoft SQL Server 2012 Integration Services

Overview

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. ...

See more details below
Paperback
$41.24
BN.com price
(Save 31%)$59.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (17) from $34.94   
  • New (13) from $34.94   
  • Used (4) from $35.11   
Microsoft SQL Server 2012 Integration Services

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$27.49
BN.com price
(Save 42%)$47.99 List Price

Overview

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
Read More Show Less

Product Details

  • ISBN-13: 9780735665859
  • Publisher: Microsoft Press
  • Publication date: 9/17/2012
  • Pages: 668
  • Sales rank: 284,145
  • Product dimensions: 7.30 (w) x 8.90 (h) x 1.30 (d)

Meet the Author

Wee-Hyong Tok is a program manager on the SQL Server Integration Services team. He has worked on several different aspects of the product. Prior to joining Microsoft, Wee Hyong was a Microsoft MVP. He is a frequent presenter at Microsoft conferences. Wee Hyong is deeply passionate about how organizations can make use of business intelligence tools to derive business insights, and make better decisions. Kaarthik Sivashanmugam is a lead software engineer on the SQL Server Integration Services team. Kaarthik joined the team during SQL Server 2005 launch and has been involved in several feature improvements to SSIS since then. Rakesh Parida is a software development engineer on the SQL Server Integration Services team. He has worked on SSIS since SQL Server 2005, and was involved in many of the new features in this release, particularly ETL frameworks, data warehousing, and SSIS based solutions. Matt Masson is a senior software development engineer on the SQL Server Integration Services team. Matt joined the team shortly after the SQL Server 2005 release, and has worked on many aspects of the product. A frequent presenter at Microsoft conferences, he is heavily involved with the SSIS community, and maintains the SSIS Team Blog Xiaoning Ding is a software development engineer on the SQL Server Integration Services team, which he joined in 2007. He has worked on the SSIS engine, SSIS server, security model, and in other areas.

Read More Show Less

Table of Contents

ForewordIntroductionPart I: OverviewChapter 1: SSIS OverviewChapter 2: Understanding SSIS ConceptsChapter 3: Upgrading to SSIS 2012Part II: DevelopmentChapter 4: New SSIS Designer FeaturesChapter 5: Team DevelopmentChapter 6: Developing an SSIS SolutionChapter 7: Understanding SSIS ConnectivityChapter 8: Working with Change Data Capture in SSIS 2012Chapter 9: Data Cleansing Using SSISPart III: Database AdminChapter 10: Configuration in SSISChapter 11: Running SSIS PackagesChapter 12: SSIS T-SQL MagicChapter 13: SSIS PowerShell MagicChapter 14: SSIS ReportsPart IV: Deep-DiveChapter 15: SSIS Engine Deep DiveChapter 16: SSIS Catalog Deep DiveChapter 17: SSIS Security Chapter 18: Understanding SSIS LoggingChapter 19: Automating SSISPart V: TroubleshootingChapter 20: Troubleshooting SSIS Package FailuresChapter 21: SSIS Performance Best PracticesChapter 22: Troubleshooting SSIS Performance IssuesChapter 23: Troubleshooting Data Issues

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)