News Flash: Wiley India Participating in the 19th Nepal International Book Fair 2015

Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer, w/cd

Author : Brian Knight, Devin Knight, Mike Davis, Wayne Snyder
Price INR : ₹.649.00
ISBN 13 : 9788126540136
ISBN 10 : 8126540133
Pages : 528
Type : Paperbound



This book and video package is geared at introducing DBAs and developers who are just starting to get a handle on Microsoft Business Intelligence tools and SQL Server Integration Services in particular. It is therefore intended to be the first book you read and the first video you watch before moving on to Knight's Professional SQL Server 2012 Integration Services. The book and accompanying video give the novice reader just enough experience with the product to start their first SSIS project.

Welcome to SSIS

Section 1: 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 SQL Server Data Tools
·    Lesson 6: Creating Your First Package
·    Lesson 7: Upgrading Packages to SQL Server 2012
·    Lesson 8: Upgrading to the Project Deployment Model

Section 2: Control Flow

·    Lesson 9: Using Precedence Constraints
·    Lesson 10: Manipulating Files with the File System Task
·    Lesson 11: Coding Custom Script Tasks
·    Lesson 12: Using the Execute SQL Task
·    Lesson 13: Using the Execute Process Task
·    Lesson 14: Using the Expression Task
·    Lesson 15: Using the Send Mail Task
·    Lesson 16: Using the Ftp Task
·    Lesson 17: Creating a Data Flow

Section 3: Data Flow

·    Lesson 18: Extracting Data from Sources
·    Lesson 19: Loading Data to a Destination
·    Lesson 20: Changing Data Types with the Data Conversion Transform
·    Lesson 21: Creating and Replacing Columns with the Derived Column Transform
·    Lesson 22: Rolling Up Data with the Aggregate Transform
·    Lesson 23: Ordering Data with the Sort Transform
·    Lesson 24: Joining Data with the Lookup Transform
·    Lesson 25: Auditing Data with the Row Count Transform
·    Lesson 26: Combining Multiple Inputs with the Union All Transform
·    Lesson 27: Cleansing Data with the Script Component
·    Lesson 28: Separating Data with the Conditional Split Transform
·    Lesson 29: Altering Rows with the Ole Db Command Transform
·    Lesson 30: Handling Bad Data with the Fuzzy Lookup
·    Lesson 31: Removing Duplicates with the Fuzzy Grouping Transform

Section 4: Making Packages Dynamic

·    Lesson 32: Making a Package Dynamic with Variables
·    Lesson 33: Making a Package Dynamic with Parameters
·    Lesson 34: Making a Connection Dynamic with Expressions
·    Lesson 35: Making a Task Dynamic with Expressions

Section 5: Common ETL Scenarios

·    Lesson 36: Loading Data Incrementally
·    Lesson 37: Using the CDC Components in SSIS
·    Lesson 38: Using Data Quality Services
·    Lesson 39: Using the DQS Cleansing Transform
·    Lesson 40: Creating a Master Package

Section 6: Containers

·    Lesson 41: Using Sequence Containers to Organize a Package
·    Lesson 42: Using For Loop Containers to Repeat Control Flow Tasks
·    Lesson 43: Using the For each Loop Container to Loop through A Collection of Objects

Section 7: Configuring Packages

·    Lesson 44: Easing Deployment with Configuration Tables
·    Lesson 45: Easing Deployment with Configuration Files
·    Lesson 46: Configuring Child Packages

Section 8: Troubleshooting SSIS

·    Lesson 47: Logging Package Data
·    Lesson 48: Using Event Handlers
·    Lesson 49: Troubleshooting Errors
·    Lesson 50: Using Data Viewers
·    Lesson 51: Using Breakpoints

Section 9: Administering SSIS

·    Lesson 52: Creating and Configuring the SSIS Catalog
·    Lesson 53: Deploying Packages to the Package Catalog
·    Lesson 54: Configuring the Packages
·    Lesson 55: Configuring the Service
·    Lesson 56: Securing SSIS Packages
·    Lesson 57: Running SSIS Packages
·    Lesson 58: Running Packages in T-SQL and Debugging Packages
·    Lesson 59: Scheduling Packages

Section 10: Loading a Warehouse

·    Lesson 60: Dimension Load
·    Lesson 61: Fact Table Load

Section 11: Wrap Up and Review

·    Lesson 62: Bringing It All Together

Appendix A: SSIS Component Crib Notes
Appendix B: Problem and Solution Crib Notes
Appendix C: What's On The DVD?

SQL Server database administrators and developers who are new to SQL Server Integration Services

Brian Knight is an independent consultant at Pragmatic Works and co-founder of He runs the Jacksonville SQL Server Users Group, is a contributing columnist for SQL Server Standard, and writes a regular column for