Knight's 24-Hour Trainer : Microsoft SQL Server 2008 Integration Services

by ; ;
  • ISBN13:


  • ISBN10:


  • Edition: 1st
  • Format: Paperback
  • Copyright: 2009-07-20
  • Publisher: Wrox
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $14.00
  • Buy New
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.


yA unique book-and-video package for learning Microsoft SQL Server Integration ServicesIf you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it.If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project Every lesson in the book is supplemented by instructional video on the DVDNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Author Biography

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.

Table of Contents

Welcome To SSIS
Installation and Getting Started
Moving Data with the Import and Export Wizard
Installing SQL Server Integration Services
Installing the Sample Databases
Creating a Solution and Project
Exploring Business Intelligence Development Studio
Creating Your First Package
Connecting Control Flow Tasks with Precedence Constraints
Manipulating Files with the File System Task
Coding Custom Script Tasks
Using the Execute SQL Task
Using the Send Mail Task
Using the FTP Task
Creating a Data Flow
Data Flow
Extracting Data from Sources
Loading Data to a Destination
Changing Data Types with the Data Conversion Transform
Creating and Replacing Columns with the Derived Column Transform
Rolling Up Data with the Aggregate Transform
Ordering Data with the Sort Transform
Joining Data with the Lookup Transform
Auditing Data with theRow Count Transform
Combining Multiple Inputs with the Union All Transform
Cleansing Data with the Script Component
Separating Data with the Conditional Split Transform
Altering Rows with the OLE DB Command Transform
Handling Bad Data with the Fuzzy Lookup Transform
Removing Duplicates with the Fuzzy Grouping Transform
Variables and Expressions
Making a Package Dynamic with Variables
Making a Connection Dynamic with Expressions
Making a Task Dynamic with Expressions
Using Sequence Containers to Organize a Package
Using For Loop Containers to Repeat Control Flow Tasks
Using the Foreach Loop Container to Loop Through a Collection of Objects
Easing Deployment with Configuration Tables
Easing Deployment with Configuration Files
Configuring Child Packages
Troubleshooting and Logging
Logging Package Data
Using Event Handlers
Troubleshooting Errors
Using Data Viewers
Using Breakpoints
Deployment and Administration
Deploying Packages
Configuring the SSIS Service
Securing SSIS Packages
Running SSIS Packages
Scheduling Packages
Data Warehousing
Loading a Dimension Table
Loading a Fact Table
Wrap Up and Review
Bringing It All Together
SSIS Component Crib Notes
Problem and Solution Crib Notes
What's on the DVD?
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review