Knight's Microsoft SQL Server 2012 integration services: 24-hour trainer

✍ Scribed by Knight, Brian

• Publisher: Wiley
• Year: 2013
• Tongue: English
• Leaves: 532
• Series: Programmer to programmer
• Category: Library

✦ Synopsis

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 KnightIncludes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the authorCovers 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.

✦ Table of Contents

Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer......Page 1
Contents......Page 15
Preface......Page 27
Welcome to SSIS......Page 33
Section I: Installation and Getting Started......Page 41
Chapter 1: Moving Data with the Import and Export Wizard......Page 43
Chapter 2: Installing SQL Server Integration Services......Page 49
Chapter 3: Installing the Sample Databases......Page 53
Chapter 4: Creating a Solution and Project......Page 57
Chapter 5: Exploring SQL Server Data Tools......Page 61
Chapter 6: Creating Your First Package......Page 67
Chapter 7: Upgrading Packages to SQL Server 2012......Page 73
Chapter 8: Upgrading to the Project Deployment Model......Page 79
Section 2: Control Flow......Page 89
Chapter 9: Using Precedence Constraints......Page 91
Chapter 10: Manipulating Files with the......Page 95
Chapter 11: Coding Custom Script Tasks......Page 103
Chapter 12: Using the Execute SQL Task......Page 111
Chapter 13: Using the Execute Process Task......Page 119
Chapter 14: Using the Expression Task......Page 125
Chapter 15: Using the Send Mail Task......Page 131
Chapter 16: Using the FTP Task......Page 139
Chapter 17: Creating a Data Flow......Page 145
Section 3: Data Flow......Page 151
Chapter 18: Extracting Data from Sources......Page 153
Chapter 19: Loading Data to a Destination......Page 171
Chapter 20: Changing Data Types......Page 183
Chapter 21: Creating and Replacing Columns with the Derived Column Transform......Page 191
Chapter 22: Rolling Up Data with the Aggregate Transform......Page 199
Chapter 23: Ordering Data with the Sort Transform......Page 205
Chapter 24: Joining Data with the Lookup Transform......Page 211
Chapter 25: Auditing Data with the Row Count Transform......Page 221
Chapter 26: Combining Multiple Inputs with the Union All Transform......Page 225
Chapter 27: Cleansing Data with the......Page 229
Chapter 28: Separating Data with the Conditional Split Transform......Page 235
Chapter 29: Altering Rows with the OLE DB Command Transform......Page 243
Chapter 30: Handling Bad Data with the Fuzzy Lookup......Page 253
Chapter 31: Removing Duplicates with the Fuzzy Grouping Transform......Page 263
Section 4: Making Packages Dynamic......Page 271
Chapter 32: Making a Package Dynamic with Variables......Page 273
Chapter 33: Making a Package Dynamic......Page 281
Chapter 34: Making a Connection Dynamic with Expressions......Page 287
Chapter 35: Making a Task Dynamic with Expressions......Page 293
Section 5: Common ETL Scenarios......Page 299
Chapter 36: Loading Data Incrementally......Page 301
Chapter 37: Using the CDC Components......Page 313
Chapter 38: Using Data Quality Services......Page 327
Chapter 39: Using the DQS Cleansing Transform......Page 341
Chapter 40: Creating a Master Package......Page 349
Section 6: Containers......Page 357
Chapter 41: Using Sequence Containers to Organize a Package......Page 359
Chapter 42: Using For Loop Containers to Repeat Control Flow Tasks......Page 363
Chapter 43: Using the Foreach Loop Container to Loop Through a Collection of Objects......Page 369
Section 7: Configuring Packages......Page 377
Chapter 44: Easing Deployment with Configuration Tables......Page 379
Chapter 45: Easing Deployment with Configuration Files......Page 389
Chapter 46: Configuring Child Packages......Page 397
Section 8: Troubleshooting SSIS......Page 405
Chapter 47: Logging Package Data......Page 407
Chapter 48: Using Event Handlers......Page 413
Chapter 49: Troubleshooting Errors......Page 419
Chapter 50: Using Data Viewers......Page 425
Chapter 51: Using Breakpoints......Page 431
Section 9: Administering SSIS......Page 437
Chapter 52: Creating and Configuring the SSIS Catalog......Page 439
Chapter 53: Deploying Packages to the Package Catalog......Page 443
Chapter 54: Configuring the Packages......Page 447
Chapter 55: Configuring the Service......Page 453
Chapter 56: Securing SSIS Packages......Page 457
Chapter 57: Running SSIS Packages......Page 463
Chapter 58: Running Packages in T-SQL and Debugging Packages......Page 469
Chapter 59: Scheduling Packages......Page 475
Section 10: Loading a Warehouse......Page 481
Chapter 60: Dimension Load......Page 483
Chapter 61: Fact Table Load......Page 491
Section 11: Wrap Up and Review......Page 495
Chapter 62: Bringing It All Together......Page 497
Appendix A: SSIS Component Crib Notes......Page 505
Appendix B: Problem and Solution Crib Notes......Page 509
Appendix C: What’s on the DVD?......Page 513
Index......Page 515
Advertisement......Page 529