Cargando…

Professional Microsoft SQL server 2012 integration services /

The 2012 release of Microsoft SQL Server Integration Services (SSIS) offers significant enhanced features that greatly expand the capabilities of this product - but only if you know how to exploit them effectively. This book shows readers how. It not only covers the latest features of the 2012 produ...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Otros Autores: Knight, Brian
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : John Wiley & Sons, Inc., 2012.
Edición:1st edition.
Colección:Programmer to programmer.
Temas:
Acceso en línea:Texto completo
Texto completo
Tabla de Contenidos:
  • Welcome to SQL server integration services
  • The SSIS tools
  • SSIS tasks
  • Containers
  • The data flow
  • Using variables, parameters, and expressions
  • Joining data
  • Creating an end-to-end package
  • Scripting in SSIS
  • Loading a data warehouse
  • Advanced data cleansing in SSIS
  • 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
  • Using SSIS with external applications
  • Administering SSIS
  • Case study : a programmatic example.