Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
- 3h 58m
- Brian Knight, Devin Knight, Mike Davis
- John Wiley & Sons (US)
- 2009
A unique book for learning Microsoft SQL Server Integration Services
If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book from foremost SSIS authority Brian Knight gets you thoroughly up to speed.
If you take full advantage of this comprehensive book, you will gain enough experience to tackle your first SSIS project with confidence.
About the Authors
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of ten SQL Server books. Brian has spoken at conferences like PASS, SQL Connections, and TechEd and many Code Camps. His blog can be found at pragmaticworks.com.
Devin Knight is a BI consultant at Pragmatic Works. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services (John Wiley & Sons, Inc.). Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, Florida, Devin is a participating member of the local users’ group (JSSUG). Visit his blog at pragmaticworks.com/community/blogs/.
Mike Davis (Jacksonville, Florida) is an author, developer, consultant, and trainer with Pragmatic Works. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Analysis Services, Database Administration, and .NET Software Development. Mike has created enterprise level BI and software solutions for numerous corporations. As a trainer he travels the world teaching classes on SQL Server and BI. He also participates as a speaker at events like SQL Saturdays, SQL Server launches, SQL server user groups, and SQL PASS.
In this Book
-
Welcome to SSIS
-
Moving Data with the Import and Export Wizard
-
Installing SQL Server Integration Services
-
Installing the Sample Databases
-
Creating a Solution and Project
-
Exploring Business Intelligence Development Studio
-
Creating Your First Package
-
Connecting Control Flow Tasks with Precedence Constraints
-
Manipulating Files with the File System Task
-
Coding Custom Script Tasks
-
Using the Execute SQL 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 Transform
-
Removing Duplicates with the Fuzzy Grouping Transform
-
Making a Package Dynamic with Variables
-
Making a Connection Dynamic with Expressions
-
Making a Task Dynamic with Expressions
-
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
-
Deploying Packages
-
Configuring the SSIS Service
-
Securing SSIS Packages
-
Running SSIS Packages
-
Scheduling Packages
-
Loading a Dimension Table
-
Loading a Fact Table
-
Bringing it All Together
-
Errata
