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

Front Cover
John Wiley & Sons, Nov 28, 2012 - Computers - 528 pages
0 Reviews

Dive into the 2012 release of SQL Server Integration Services with this book-and-video package

This book-and-video package teaches you the essential elements of Microsoft SQL Server Integration Services (SSIS) from the ground up—no previous knowledge of SSIS is required. Each lesson is streamlined to teach a specific component of SSIS, helping you to learn just what you need to succeed. The lessons include three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson, all of which present you with a thorough introduction to Microsoft business intelligence tools and SSIS.

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

  • Furnishes you with all the information you need to confidently start your first SSIS project
  • Integrates instructional videos with each of the hands-on lessons found in the book
  • Provides expert instruction from leading SQL Server authorities
  • Covers the latest changes and updates in the SQL Server 2012 release

The 24-Hour Trainer is a unique book-and-video package that delivers step-by-step lessons for handling real-world scenarios. Each lesson in the book is accompanied by an instructional video that reinforces the content while providing additional explanations and tips.

On the DVD

Don't just learn—do!

The lessons within the book are each accompanied by an instructional demonstration on the DVD.

You'll learn to:

  • Create your first package
  • Upgrade packages to SQL Server 2012
  • Use a variety of tasks
  • Use Data Quality Services to cleanse data
  • Incrementally load data
  • Load a data warehouse
  • Roll up, order, join, audit, cleanse, and separate data
  • Deploy, configure, and schedule packages

Please see the DVD appendix for details and complete system requirements.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

MAKING PACKAGES DYNAMIC LESSON 32 MAKING A PACKAGE DYNAMIC WITH VARIABLES
241
MAKING A PACKAGE DYNAMIC
249
MAKING A CONNECTION DYNAMIC
255
MAKING A TASK DYNAMIC WITH EXPRESSIONS
261
COMMON ETL SCENARIOS
267
USING THE CDC COMPONENTS IN SSIS
281
USING DATA QUALITY SERVICES
295
USING THE DQS CLEANSING TRANSFORM
309

UPGRADING PACKAGES TO SQL SERVER 2012
41
SECTION 8
47
SECTION 2 CONTROL FLOW
57
USING PRECEDENCE CONSTRAINTS
59
SECTION 10
60
CONTENTS
63
CODING CUSTOM SCRIPT TASKS
71
USING THE EXECUTE SQL TASK
79
USING THE EXECUTE PROCESS TASK
87
USING THE EXPRESSION TASK
93
USING THE SEND MAIL TASK
99
USING THE FTP TASK
107
CREATING A DATA FLOW
113
SECTION 3 DATA FLOW
119
LOADING DATA TO A DESTINATION
139
Excel Destination
147
with the Derived Column Transform
159
ROLLING UP DATA WITH THE AGGREGATE TRANSFORM
167
ORDERING DATA WITH THE SORT TRANSFORM
173
JOINING DATA WITH THE LOOKUP TRANSFORM
179
AUDITING DATA WITH THE ROW COUNT TRANSFORM
189
CLEANSING DATA WITH
197
SEPARATING DATA WITH
203
COMMAND TRANSFORM
211
HANDLING BAD DATA WITH THE FUZZY LOOKUP
221
REMOVING DUPLICATES WITH
231
USING SEQUENCE CONTAINERS
325
Using Sequence Containers to Organize a Package
327
REPEAT CONTROL FLOW TASKS
331
TO LOOP THROUGH A COLLECTION OF OBJECTS
337
EASING DEPLOYMENT WITH CONFIGURATION FILES
357
CONFIGURING CHILD PACKAGES
365
TROUBLESHOOTING SSIS
373
Using Event Handlers
381
Troubleshooting Errors
387
Using Data Viewers
393
Using Breakpoints
399
ADMINISTERING SSIS
405
ADMINISTERING SSIS LESSON 52 CREATING AND CONFIGURING THE SSIS CATALOG
407
Deploying Packages to the Package Catalog
411
CONFIGURING THE PACKAGES
415
Configuring the Service
421
Running SSIS Packages
431
Running Packages in TSQL and Debugging Packages
437
Scheduling Packages
443
LOADING A WAREHOUSE
449
Fact Table Load
459
Bringing It All Together
465
SSIS Component Crib Notes
473
Whats on the DVD?
481
Copyright

Other editions - View all

Common terms and phrases

About the author (2012)

Brian Knight, SQL Server MVP, is the founder of Pragmatic Works. He is the author of more than a dozen books.

Devin Knight, MCTS, MCITP, is an author, consultant, and trainer with Pragmatic Works.

Mike Davis, MCTS, MCITP, is an author, developer, consultant, and trainer with Pragmatic Works.

Wayne Snyder, SQL Server MVP, is a Distinguished Architect at Mariner focused on business intelligence.

Bibliographic information