Microsoft® SQL ServerTM 2005 Integration Services Step by Step
Teach yourself the fundamentals of SQL Server Integration Services-one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data-and build solutions that support your business intelligence needs. Discover how to: Design and execute p...
| Main Author: | |
|---|---|
| Other Authors: | , , , , |
| Format: | eBook |
| Language: | Inglés |
| Published: |
Sebastopol :
Microsoft Press
2010.
|
| Edition: | 1st edition |
| Series: | Step by step
|
| Subjects: | |
| See on Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626975906719 |
Table of Contents:
- Cover; Copyright Page; Additional Resources for Web Developers; Contents at a Glance; Table of Contents; Introduction; Finding Your Best Starting Point; About the Companion CD-ROM; System Requirements; Installing and Using the Sample Files; How to Access Select CD Content; Conventions and Features in This Book; Part I: Getting Started with Integration Services; Chapter 1: Introduction to SQL Server Integration Services; Common SSIS Applications; SSIS Objects and Process Control Components; SSIS Process Control; SSIS Control Flow; SSIS Data Flow; SSIS Data Pipeline; SSIS Event Handler
- SSIS ComponentsSSIS Development Studio; SSIS Runtime Services; SSIS Package Deployment; SQL Server 2000 DTS Migration; Chapter 1 Quick Reference; Chapter 2: Building Your First Package; Exploring Business Intelligence Development Studio; Solution Explorer; Docking Utility Windows; Exploring an SSIS Project in BIDS; Using the SSIS Import and Export Wizard; Creating Tables in a New Database; Reviewing Package Elements; Reviewing a Package Created Using the Import and Export Wizard; Testing a Package; Executing the Package in the Designer; Chapter 2 Quick Reference; Part II: Designing Packages
- Chapter 3: Extracting and Loading DataConnection Managers; Connection Manager Types; Creating a New Integration Services Project; Adding Connection Managers; Creating a Data Flow; Adding Data Adapters; Executing the Package; Using Data Sources and Data Source Views; Creating a Data Source; Creating a Data Source View; Creating a New Named Query; Copying Data from a Named Query to a Flat File; Executing the Package; Chapter 3 Quick Reference; Chapter 4: Using Data Flow Transformations; Creating Data Flow in a Package; Data Flow Sources; Data Flow Transformations; Data Flow Destinations
- Data Source ConnectionsSSIS Transformations; Row Transformations; Rowset Transformations; Split and Join Transformations; Data Quality Transformations; Data-Mining Transformations; Other Transformations; Synchronous and Asynchronous Transformations; Using Expressions in Packages; Expression Usage in SSIS; Expressions Elements; Building Expressions; Using Data Flow Transformations; Opening and Exploring the SSIS Project; Creating the Data Flow Task; Using a Flat File Source; Adding a Connection Manager; Adding a Conditional Split Transformation; Adding a Derived Column Transformation
- Viewing the Properties of the Derived Column TransformationAdding a Flat File Destination Data Adapter and Executing the Package; Sending Output to Different Destinations; Configuring Error Output; Types of Errors; Error Options; Exploring the LookupGeography Package; Creating a Task; Creating and Naming a Flat File Source; Adding a Data Conversion Transformation; Adding a Lookup Transformation; Adding a Flat File Destination for Lookup Errors; Adding a Flat File Destination for Successful Lookups; Executing the Package and Checking the Results; Chapter 4 Quick Reference
- Chapter 5: Managing Control Flow
