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...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianpolis, IN :
Wiley
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627628206719 |
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
- Lesson 33: Using the Foreach Loop Container to Loop Through a Collection of Objects
