BN.com Gift Guide

Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services [NOOK Book]

Overview

Don't let SQL Server Integration Services (SSIS) intimidate you. Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services is a unique lesson-based book that walks you through the essential parts of SSIS without all of the fluff. Each lesson is streamlined to teach a specific component of SSIS, helping you to focus on just what you need in order to succeed in your job. If you learn better by getting your hands on the product, this book provides you with a ...

See more details below
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 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)
$28.49
BN.com price
(Save 43%)$49.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Don't let SQL Server Integration Services (SSIS) intimidate you. Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services is a unique lesson-based book that walks you through the essential parts of SSIS without all of the fluff. Each lesson is streamlined to teach a specific component of SSIS, helping you to focus on just what you need in order to succeed in your job. If you learn better by getting your hands on the product, this book provides you with a step-by-step lab for each lesson with a video to accompany it.

The authors guide you from the ground-up and make no assumption of previous knowledge of SSIS. The 49 featured lessons help you develop a strong foundation for this highly marketable skill. Additionally, you'll get useful tools like cheat sheets on the SSIS expression language and you'll learn when to use each task.

Each lesson has three major components: a description of how to use the given SSIS feature, a tutorial, and an instructor-led video. No matter your learning style, you'll glean new information from each lesson with this unique style of training. It's like having a one-on-one instructor in your office showing you SSIS. Learning SSIS has never been so simple.

What you will learn from this book and DVD

  • How to install and configure SSIS
  • How to create and edit tasks in the Control Flow

  • Methods for designing the core sources, transforms, and destinations of Data Flows

  • How to develop Control Flows with For Loop and Foreach Loop Containers

  • How to make your package dynamic with variables and expressions

  • Methods for updating your package remotely with configuration files and tables

  • Techniques for transferring information from parent to child packages

  • Techniques for loading a data warehouse using SSIS

  • Tips for troubleshooting common SSIS challenges

Who this book is for

This book is for SQL Server database administrators and developers who are new to SSIS.

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

Read More Show Less

Product Details

  • ISBN-13: 9781118287446
  • Publisher: Wiley
  • Publication date: 11/30/2011
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 384
  • File size: 8 MB

Meet the Author

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of ten SQL Server books. Brian has spoken at conferences like PASS, SQL Connections, and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com. Brian watches his 401k wither away in Jacksonville, Florida.

Devin Knight is a BI consultant at Pragmatic Works. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services (John Wiley & Sons, Inc.). Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, Florida, Devin is a participating member of the local users’ group (JSSUG). Visit his blog at http://pragmaticworks.com/community/blogs/.

Mike Davis (Jacksonville, Florida) is an author, developer, consultant, and trainer with Pragmatic Works. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Analysis Services, Database Administration, and .NET Software Development. Mike has created enterprise level BI and software solutions for numerous corporations. As a trainer he travels the world teaching classes on SQL Server and BI. He also participates as a speaker at events like SQL Saturdays, SQL Server launches, SQL server user groups, and SQL PASS. In his spare time Mike plays guitar and darts. He is a member of the North Florida Dart League.

Read More Show Less

Table of Contents

Preface.

Welcome To SSIS.

Section I: Installation and Getting Started

Lesson 1: Moving Data with the Import and Export Wizard.

Lesson 2: Installing SQL Server Integration Services.

Lesson 3: Installing the Sample Databases.

Lesson 4: Creating a Solution and Project.

Lesson 5: Exploring Business Intelligence Development Studio.

Lesson 6: Creating Your First Package.

Section II: Tasks.

Lesson 7: Connecting Control Flow Tasks with Precedence Constraints.

Lesson 8: Manipulating Files with the File System Task.

Lesson 9: Coding Custom Script Tasks.

Lesson 10: Using the Execute SQL Task.

Lesson 11: Using the Send Mail Task.

Lesson 12: Using the FTP Task.

Lesson 13: Creating a Data Flow.

Section III: Data Flow.

Lesson 14: Extracting Data from Sources.

Lesson 15: Loading Data to a Destination.

Lesson 16: Changing Data Types with the Data Conversion Transform.

Lesson 17: Creating and Replacing Columns with the Derived Column Transform.

Lesson 18: Rolling Up Data with the Aggregate Transform.

Lesson 19: Ordering Data with the Sort Transform.

Lesson 20: Joining Data with the Lookup Transform.

Lesson 21: Auditing Data with theRow Count Transform.

Lesson 22: Combining Multiple Inputs with the Union All Transform.

Lesson 23: Cleansing Data with the Script Component.

Lesson 24: Separating Data with the Conditional Split Transform.

Lesson 25: Altering Rows with the OLE DB Command Transform.

Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform.

Lesson 27: Removing Duplicates with the Fuzzy Grouping Transform.

Section IV: Variables and Expressions.

Lesson 28: Making a Package Dynamic with Variables.

Lesson 29: Making a Connection Dynamic with Expressions.

Lesson 30: Making a Task Dynamic with Expressions.

Section V: Containers.

Lesson 31: Using Sequence Containers to Organize a Package.

Lesson 32: Using For Loop Containers to Repeat Control Flow Tasks.

Lesson 33: Using the Foreach Loop Container to Loop Through a Collection of Objects.

Section VI: Configuration.

Lesson 34: Easing Deployment with Configuration Tables.

Lesson 35: Easing Deployment with Configuration Files.

Lesson 36: Configuring Child Packages.

Section VII: Troubleshooting and Logging.

Lesson 37: Logging Package Data.

Lesson 38: Using Event Handlers.

Lesson 39: Troubleshooting Errors.

Lesson 40: Using Data Viewers.

Lesson 41: Using Breakpoints.

Section VIII: Deployment and Administration.

Lesson 42: Deploying Packages.

Lesson 43: Configuring the SSIS Service.

Lesson 44: Securing SSIS Packages.

Lesson 45: Running SSIS Packages.

Lesson 46: Scheduling Packages.

Section IX: Data Warehousing.

Lesson 47: Loading a Dimension Table.

Lesson 48: Loading a Fact Table.

Section X: Wrap Up and Review.

Lesson 49: Bringing It All Together.

Appendix A: SSIS Component Crib Notes.

Appendix B: Problem and Solution Crib Notes.

Appendix C: What’s on the DVD?

Index.

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
Sort by: Showing all of 3 Customer Reviews
  • Posted November 30, 2011

    Great starting point for SSIS.

    I have three books on SSIS for SQL Server 2005/2008. This book really helped me get started because it cuts to the point. The DVD that accompanies the book is easy to understand and helps you follow along the step by step process. Will look for the authors other works for sure.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted October 29, 2011

    Great Book

    It is great book and the video tutorials are excellent.

    Was this review helpful? Yes  No   Report this review
  • Posted December 8, 2010

    Fast way to get started with SSIS

    The book covers all the major components of SSIS at a basic level. The book is written in a step by step style to help you get started using SSIS immediately. The videos cover the chapters almost verbatim, but the audio was sometimes hard to hear. The video tutorials are worth the price of the book if you just have one weekend to prepare to start using SSIS.

    This team of authors is well respected and did a great job covering SSIS.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 3 Customer Reviews

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