Preface | |
Welcome To SSIS | |
Installation and Getting Started | |
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 | |
Tasks | |
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 | |
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 theRow 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 | |
Variables and Expressions | |
Making a Package Dynamic with Variables | |
Making a Connection Dynamic with Expressions | |
Making a Task Dynamic with Expressions | |
Containers | |
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 | |
Configuration | |
Easing Deployment with Configuration Tables | |
Easing Deployment with Configuration Files | |
Configuring Child Packages | |
Troubleshooting and Logging | |
Logging Package Data | |
Using Event Handlers | |
Troubleshooting Errors | |
Using Data Viewers | |
Using Breakpoints | |
Deployment and Administration | |
Deploying Packages | |
Configuring the SSIS Service | |
Securing SSIS Packages | |
Running SSIS Packages | |
Scheduling Packages | |
Data Warehousing | |
Loading a Dimension Table | |
Loading a Fact Table | |
Wrap Up and Review | |
Bringing It All Together | |
SSIS Component Crib Notes | |
Problem and Solution Crib Notes | |
What's on the DVD? | |
Index | |
Table of Contents provided by Publisher. All Rights Reserved. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.