Pro SQL Server 2012 Integration Services
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your compa...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, Calif. :
Apress
2012.
|
| Edición: | 1st ed. 2012. |
| Colección: | The expert's voice in SQL server
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629437706719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Dedication Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewer; CHAPTER 1 Introducing Integration Services; A Brief History of Microsoft ETL; What Can SSIS Do for You?; What Is Enterprise ETL?; SSIS Architecture; New SSIS Features; Our Favorite People and Places; Summary; CHAPTER 2 BIDS and SSMS; SQL Server Business Intelligence Development Studio; Analysis Services Project; Integration Services Project; Report Server Project Wizard; Report Server Project; Import Analysis Services Database
- Integration Services Project WizardReport Model Project; Integration Services; Project Files; Tool Windows; Designer Window; Resolve References; SSIS Toolbox; Package Code View; SQL Server Management Studio; Tool Windows; SQL Server Management Studio Project; Templates; Code Snippets; Queries for SSIS; Summary; CHAPTER 3 Hello World-Your First SSIS 2012 Package; Integration Services Project; Key Package Properties; Package Annotations; Package Property Categories; Hello World; Flat File Source Connection; OLE DB Destination Connection; Data Flow Task; Source Component; Destination Component
- Data Flow PathMapping; Execution; Real World; Control Flow; Execute SQL Task; Data Flow Task; Summary; CHAPTER 4 Connection Managers; Commonly Used Connection Managers; OLE DB Connection Managers; File Connection Managers; ADO.NET Connection Manager; Cache Connection Manager; Other Connection Managers; FTP Connection Manager; HTTP Connection Manager; MSOLAP100 Connection Manager; DQS Connection Manager; MSMQ Connection Manager; SMO Connection Manager; SMTP Connection Manager; SQLMOBILE Connection Manager; WMI Connection Manager; Summary; CHAPTER 5 Control Flow Basics; What Is a Control Flow?
- SSIS Toolbox for Control FlowFavorite Tasks; Data Flow Task; Execute SQL Task; Execute SQL Task Editor-General Page; Execute SQL Task Editor-Parameter Mapping Page; Execute SQL Task Editor-Result Set Page; Execute SQL Task Editor-Expressions Page; Common Tasks; Analysis Services Processing Task; Analysis Services Processing Task Editor-General Page; Analysis Services Processing Task Editor-Processing Settings Page; Bulk Insert Task; Considerations Before Using the Bulk Insert Task; Bulk Insert Task Editor-Connection Page; Bulk Insert Task Editor-Options Page; Data Profiling Task
- Data Profiling Task Editor-General PageData Profiling Task Editor-Profile Requests Page; Execute Package Task; Execute Package Task Editor-Package Page; Execute Package Task Editor-Parameter Bindings Page; Execute Process Task; File System Task; FTP Task; FTP Task Editor-General Page; FTP Task Editor-File Transfer Page; Script Task; Send Mail Task; Web Service Task; Web Service Task Editor-General Page; Web Service Task Editor-Input Page; XML Task; Precedence Constraints; Basic Containers; Containers; Groups; Breakpoints; Summary; CHAPTER 6 Advanced Control Flow Tasks; Advanced Tasks
- Analysis Services Execute DDL Task
