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

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

Book-and-video package gets novices up to speed on Microsoft SQL Server 2012

If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes 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. It's a complete learning package that will give you the confidence you need to start your first SSIS project.

  • Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS)
  • Provides expert instruction from leading SQL Server authority and author, Brian Knight
  • Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author
  • Covers the very latest changes and updates in the SQL Server 2012 release

Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating.

Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.

 

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