Bibliograph

Professional Microsoft SQL server 2012 integration services, Brian Knight [and others]

Type

Label

Professional Microsoft SQL server 2012 integration services, Brian Knight [and others]

Language

eng

Illustrations

illustrations

Index

index present

Literary Form

non fiction

Main title

Professional Microsoft SQL server 2012 integration services

Nature of contents

dictionaries

Oclc number

1787849868

Responsibility statement

Brian Knight [and others]

Series statement

Wrox Programmer to Programmer

Summary

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 product release, it teaches the best practices for using them effectively. Each chapter includes helpful case studies and tutorial examples - all based on years of the authors' real-world experience - to better illustrate concepts and techniques.--description from back cover

Table Of Contents

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

Contributor