Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
- 5h 59m
- Brian Knight, Devin Knight, Mike Davis, Wayne Snyder
- John Wiley & Sons (US)
- 2013
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book 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. 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
- 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.
About the Authors
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.
In this Book
-
Moving Data with the Import and Export Wizard
-
Installing SQL Server Integration Services
-
Installing the Sample Databases
-
Creating a Solution and Project
-
Exploring SQL Server Data Tools
-
Creating Your First Package
-
Upgrading Packages to SQL Server 2012
-
Upgrading to the Project Deployment Model
-
Using Precedence Constraints
-
Manipulating Files with the File System Task
-
Coding Custom Script Tasks
-
Using the Execute SQL Task
-
Using the Execute Process Task
-
Using the Expression Task
-
Using the Send Mail Task
-
Using the FTP Task
-
Creating a 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 the Row 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
-
Removing Duplicates with the Fuzzy Grouping Transform
-
Making a Package Dynamic with Variables
-
Making a Package Dynamic with Parameters
-
Making a Connection Dynamic with Expressions
-
Making a Task Dynamic with Expressions
-
Loading Data Incrementally
-
Using the CDC Components in SSIS
-
Using Data Quality Services
-
Using the DQS Cleansing Transform
-
Creating a Master Package
-
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
-
Logging Package Data
-
Using Event Handlers
-
Troubleshooting Errors
-
Using Data Viewers
-
Using Breakpoints
-
Creating and Configuring the SSIS Catalog
-
Deploying Packages to the Package Catalog
-
Configuring the Packages
-
Configuring the Service
-
Securing SSIS Packages
-
Running SSIS Packages
-
Running Packages in T-SQL and Debugging Packages
-
Scheduling Packages
-
Dimension Load
-
Fact Table Load
-
Bringing it All Together
