Cargando…

Professional Microsoft SQL Server 2014 integration services /

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Knight, Brian (Autor), Knight, Devin (Autor), Moss, Jessica M. (Autor), Davis, Mike (Autor), Rock, Chris (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : John Wiley & Sons, [2014]
Colección:Wrox: Programmer to Programmer
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Welcome to SQL server integration services
  • The SSIS tools
  • SSIS tasks
  • The data flow
  • Using variables, parameters, and expressions
  • Containers
  • Joining data
  • Creating an end-to-end package
  • Scripting in SSIS
  • Advanced data cleansing in SSIS
  • Incremental loads in SSIS
  • Loading a data warehouse
  • Using the relational engine
  • Accessing heterogeneous data
  • Reliability and scalability
  • Understanding and tuning the data flow engine
  • SSIS software development life cycle
  • Error and event handling
  • Programming and extending SSIS
  • Adding a user interface to your component
  • External management and WMI task implementation
  • Administering SSIS.