SQL Server 2012 data integration recipes
SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, Calif. : New York :
Apress ; Distributed to the book trade worldwide by Springer
c2012.
|
| Edición: | 1st ed. 2012. |
| Colección: | Expert's voice in SQL server
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629375906719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Dedication Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewers; Acknowledgments; Introduction; CHAPTER 1 Sourcing Data from MS Office Applications; 1-1. Ensuring Connectivity to Access and Excel; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-2. Importing Data from Excel; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-3. Modifying Excel Data During a Load; Problem; Solution; Querying the Source Data; Altering the Destination Table Name; Replacing the Data in the Destination Table
- Enabling Identity InsertAdjusting Column Mappings; Changing Field Types for New Tables; Creating an SQL Server Integration Services (SSIS) Package from the Import/Export Wizard; How It Works; Hints, Tips, and Traps; 1-4. Specifying the Excel Data to Load During an Ad-Hoc Import; Problem; Solution; How It Works; 1-5. Planning for Future Use of a Linked Server; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-6. Reading Data Automatically from an Excel Worksheet; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-7. Loading Excel Data as Part of a Structured ETL Process
- ProblemSolution; How It Works; Hints, Tips, and Traps; 1-8. Importing Excel 2007/2010 Data Using SSIS 2005; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-9. Handling Source Data Issues When Importing Excel Worksheets Using SSIS; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-10. Pushing Access Data into SQL Server; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-11. Importing Multiple Access Tables; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-12. Ad Hoc Imports of Access Data; Problem; Solution; How It Works; Hints, Tips, and Traps
- 1-13. Obtaining Access Data Without Regular ImportsProblem; Solution; How It Works; Hints, Tips, and Traps; 1-14. Importing Access Data as Part of a Regular ETL Process; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-15. Convert a Complex Access Database to SQL Server; Problem; Solution; How It Works; Hints, Tips, and Traps; 1-16. Resolving Complex Data Migration Problems During an Access to SQL Server Upgrade; Problem; Solution; Use SSMA to Alter Data Types; Use SSMA to Migrate Data for a Single Table; Use SSMA to Create a Report on a Table or Tables
- Use SSMA to Apply Custom Data Type Mapping for a ProjectUse SSMA to Create T-SQL Scripts of Destination Tables; Use SSMA to Find All the Access Databases on Any Drives to Which Your Computer is Connected; How It Works; Hints, Tips, and Traps; Summary; CHAPTER 2 Flat File Data Sources; 2-1. Importing Data From a Text File; Problem; Solution; How It Works; Hints, Tips, and Traps; 2-2. Importing a Delimited Text File; Problem; Solution; How It Works; 2-3. Automatically Determining Data Types; Problem; Solution; How It Works; Hints, Tips, and Traps; 2-4. Importing Fixed-Width Text Files; Problem
- Solution
