Cargando…
Knight's 24-hour trainer : Microsoft SQL server 2008 integration services /
A unique book-and-video package 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 and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub.,
©2009.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services; About the Authors; Acknowledgments; Contents; Preface; Who This Book Is For; What This Book Covers; How This Book Is Structured; What This Book Covers; Instructional Videos on DVD; Conventions; Supporting Packages and Code; Errata; p2p.wrox.com; Welcome to SSIS; Import and Export Wizard; The Business Intelligence Development Studio; Architecture; Editions of SQL Server 2008; Summary; Section I: Installation and Getting Started; Lesson 1: Moving Data with the Import and Export Wizard; Try It
- Lesson 2: Installing SQL Server Integration ServicesLesson 3: Installing the Sample Databases; Try It; Lesson 4: Creating a Solution and Project; Try It; Lesson 5: Exploring Business Intelligence Development Studio; The Solution Explorer; The Properties Window; The Toolbox; The BIDS Design Environment; Lesson 6: Creating Your First Package; Creating and Using Connection Managers; Using and Configuring Tasks; Exploring Package Encryption; Executing Packages; Try It; Section II: Tasks; Lesson 7: Connecting Control Flow Tasks with Precedence Constraints; Try It
- Lesson 8: Manipulating Files with the File System TaskTry It; Lesson 9: Coding Custom Script Tasks; Try It; Lesson 10: Using the Execute SQL Task; Try It; Lesson 11: Using the Send Mail Task; Try It; Lesson 12: Using the FTP Task; Try It; Lesson 13: Creating a Data Flow; Try It; Section III: Data Flow; Lesson 14: Extracting Data from Sources; OLE DB Source; Excel Source; Flat File Source; Lesson 15: Loading Data to a Destination; OLE DB Destination; Flat File Destination; Excel Destination; Lesson 16: Changing Data Types with the Data Conversion Transform; Try It
- Lesson 17: Creating and Replacing Columns with the Derived Column TransformTry It; Lesson 18: Rolling Up Data with The Aggregate Transform; Try It; Lesson 19: Ordering Data with the Sort Transform; Try It; Lesson 20: Joining Data with the Lookup Transform; Cache Modes; The Cache Connection Manager and Transform; Lesson 21: Auditing Data with the Row Count Transform; Try It; Lesson 22: Combining Multiple Inputs with the Union All Transform; Try It; Lesson 23: Cleansing Data with the Script Component; Try It; Lesson 24: Separating Data with the Conditional Split Transform; Try It
- Lesson 25: Altering Rows with the OLE DB Command TransformTry It; Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform; Try It; Lesson 27: Removing Duplicates with the Fuzzy Grouping Transform; Try It; Section IV: Variables and Expressions; Lesson 28: Making a Package Dynamic with Variables; Try It; Lesson 29: Making a Connection Dynamic with Expressions; Try It; Lesson 30: Making a Task Dynamic with Expressions; Try It; Section V: Containers; Lesson 31: Using Sequence Containers to Organize a Package; Try It; Lesson 32: Using For Loop Containers to Repeat Control Flow Tasks; Try It