Professional SQL Server 2008 integration services [[electronic resource] /] / Brian Knight ... [et al.] |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2008 |
Descrizione fisica | 1 online resource (1010 p.) |
Disciplina |
005.75/85
005.7585 |
Altri autori (Persone) | KnightBrian <1976-> |
Collana | Wrox professional guides |
Soggetto topico | Database management |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-05956-5
1-281-83701-6 9786611837013 0-470-41768-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Professional SQL Server 2008 Integration Services; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Getting Started; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard
Business Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Package Installation Wizard; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Looping and Sequence Tasks; Scripting Tasks; Analysis Services Tasks; Data Flow Task; Data Preparation Tasks; RDBMS Server Tasks; Workflow Tasks; SMO Administration Tasks; Summary; Chapter 4: Containers; Task Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Summary; Chapter 5: The Data Flow; The Data Flow; Data Viewers; Sources DestinationsTransformations; Data Flow Example; Summary; Chapter 6: Using Expressions and Variables; The Paradigm; Understanding Data Types; Using Variables; Working with Expressions; Summary; Chapter 7: Joining Data; The Lookup Component; The Merge Join Component; Contrasting to the Relational Join; New Lookup Features; Building the Basic Package; Using the Lookup Component; Cache Connection Manager and Transform; Summary; Chapter 8: Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary Chapter 9: Scripting in SSISScripting?; Getting Started in SSIS Scripting; Using the Script Task; Using the Script Component; Essential Coding, Debugging, and Troubleshooting Techniques; Summary; Chapter 10: Loading a Data Warehouse; Data Profiling; Data Extraction; Dimension Table Loading; Fact Table Loading; SSAS Processing; Master ETL Package; Summary; Chapter 11: Using the Relational Engine; Data Extraction; SQL Server 2008 Change Data Capture; Data Loading; Summary; Chapter 12: Accessing Heterogeneous Data; Excel and Access; Oracle; XML and Web Services; Flat Files; ODBC Other Heterogeneous SourcesSummary; Chapter 13: Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 14: Understanding and Tuning the Data Flow Engine; The SSIS Engine; SSIS Data Flow Design and Tuning; Pipeline Performance Monitoring; Summary; Chapter 15: Source Control and Software Development Life Cycle; Introduction to Software Development Life Cycles; Versioning and Source Code Control; Code Deployment and Promotion from Development to Test to Production; Summary; Chapter 16: DTS 2000 Migration Managing DTS 2000 Packages within SQL Server Management Studio |
Record Nr. | UNINA-9910453198903321 |
Indianapolis, IN, : Wiley Pub., c2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Professional SQL Server 2008 integration services [[electronic resource] /] / Brian Knight ... [et al.] |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2008 |
Descrizione fisica | 1 online resource (1010 p.) |
Disciplina |
005.75/85
005.7585 |
Altri autori (Persone) | KnightBrian <1976-> |
Collana | Wrox professional guides |
Soggetto topico | Database management |
ISBN |
1-118-05956-5
1-281-83701-6 9786611837013 0-470-41768-4 |
Classificazione | 54.53 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Professional SQL Server 2008 Integration Services; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Getting Started; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard
Business Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Package Installation Wizard; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Looping and Sequence Tasks; Scripting Tasks; Analysis Services Tasks; Data Flow Task; Data Preparation Tasks; RDBMS Server Tasks; Workflow Tasks; SMO Administration Tasks; Summary; Chapter 4: Containers; Task Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Summary; Chapter 5: The Data Flow; The Data Flow; Data Viewers; Sources DestinationsTransformations; Data Flow Example; Summary; Chapter 6: Using Expressions and Variables; The Paradigm; Understanding Data Types; Using Variables; Working with Expressions; Summary; Chapter 7: Joining Data; The Lookup Component; The Merge Join Component; Contrasting to the Relational Join; New Lookup Features; Building the Basic Package; Using the Lookup Component; Cache Connection Manager and Transform; Summary; Chapter 8: Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary Chapter 9: Scripting in SSISScripting?; Getting Started in SSIS Scripting; Using the Script Task; Using the Script Component; Essential Coding, Debugging, and Troubleshooting Techniques; Summary; Chapter 10: Loading a Data Warehouse; Data Profiling; Data Extraction; Dimension Table Loading; Fact Table Loading; SSAS Processing; Master ETL Package; Summary; Chapter 11: Using the Relational Engine; Data Extraction; SQL Server 2008 Change Data Capture; Data Loading; Summary; Chapter 12: Accessing Heterogeneous Data; Excel and Access; Oracle; XML and Web Services; Flat Files; ODBC Other Heterogeneous SourcesSummary; Chapter 13: Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 14: Understanding and Tuning the Data Flow Engine; The SSIS Engine; SSIS Data Flow Design and Tuning; Pipeline Performance Monitoring; Summary; Chapter 15: Source Control and Software Development Life Cycle; Introduction to Software Development Life Cycles; Versioning and Source Code Control; Code Deployment and Promotion from Development to Test to Production; Summary; Chapter 16: DTS 2000 Migration Managing DTS 2000 Packages within SQL Server Management Studio |
Record Nr. | UNINA-9910782341503321 |
Indianapolis, IN, : Wiley Pub., c2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Professional SQL Server 2008 integration services [[electronic resource] /] / Brian Knight ... [et al.] |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2008 |
Descrizione fisica | 1 online resource (1010 p.) |
Disciplina |
005.75/85
005.7585 |
Altri autori (Persone) | KnightBrian <1976-> |
Collana | Wrox professional guides |
Soggetto topico | Database management |
ISBN |
1-118-05956-5
1-281-83701-6 9786611837013 0-470-41768-4 |
Classificazione | 54.53 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Professional SQL Server 2008 Integration Services; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Getting Started; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard
Business Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Package Installation Wizard; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Looping and Sequence Tasks; Scripting Tasks; Analysis Services Tasks; Data Flow Task; Data Preparation Tasks; RDBMS Server Tasks; Workflow Tasks; SMO Administration Tasks; Summary; Chapter 4: Containers; Task Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Summary; Chapter 5: The Data Flow; The Data Flow; Data Viewers; Sources DestinationsTransformations; Data Flow Example; Summary; Chapter 6: Using Expressions and Variables; The Paradigm; Understanding Data Types; Using Variables; Working with Expressions; Summary; Chapter 7: Joining Data; The Lookup Component; The Merge Join Component; Contrasting to the Relational Join; New Lookup Features; Building the Basic Package; Using the Lookup Component; Cache Connection Manager and Transform; Summary; Chapter 8: Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary Chapter 9: Scripting in SSISScripting?; Getting Started in SSIS Scripting; Using the Script Task; Using the Script Component; Essential Coding, Debugging, and Troubleshooting Techniques; Summary; Chapter 10: Loading a Data Warehouse; Data Profiling; Data Extraction; Dimension Table Loading; Fact Table Loading; SSAS Processing; Master ETL Package; Summary; Chapter 11: Using the Relational Engine; Data Extraction; SQL Server 2008 Change Data Capture; Data Loading; Summary; Chapter 12: Accessing Heterogeneous Data; Excel and Access; Oracle; XML and Web Services; Flat Files; ODBC Other Heterogeneous SourcesSummary; Chapter 13: Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 14: Understanding and Tuning the Data Flow Engine; The SSIS Engine; SSIS Data Flow Design and Tuning; Pipeline Performance Monitoring; Summary; Chapter 15: Source Control and Software Development Life Cycle; Introduction to Software Development Life Cycles; Versioning and Source Code Control; Code Deployment and Promotion from Development to Test to Production; Summary; Chapter 16: DTS 2000 Migration Managing DTS 2000 Packages within SQL Server Management Studio |
Record Nr. | UNINA-9910819114203321 |
Indianapolis, IN, : Wiley Pub., c2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|