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...

Full description

Bibliographic Details
Main Author: Rodrigues, Francis
Other Authors: Coles, Michael, Dye, David
Format: eBook
Language:English
Published: [Berkeley, CA] Apress 2012
Series:The expert's voice in SQL server
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 03345nmm a2200493 u 4500
001 EB001941513
003 EBX01000000000000001104415
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781430236931 
020 |a 1430236930 
020 |a 9781430236948 
050 4 |a QA76.9.C55 
100 1 |a Rodrigues, Francis 
245 0 0 |a Pro SQL server 2012 integration services  |c Francis Rodrigues, Michael Coles, David Dye 
260 |a [Berkeley, CA]  |b Apress  |c 2012 
300 |a xviii, 617 pages  |b illustrations 
505 0 |a Introducing integration services -- BIDS and SSMS -- Hello world-your first SSIS 2012 package -- Connection managers -- Control flow basics -- Advanced control flow tasks -- Source and destination adapters -- Data flow transformations -- Variables, parameters, and expressions -- Scripting -- Events and error handling -- Data profiling and scrubbing -- Logging and auditing -- Heterogeneous sources and destinations -- Data flow tuning and optimization -- Parent-child design pattern -- Dimensional data ETL -- Building robust solutions -- Deployment model 
653 |a Client/server computing / fast 
653 |a Bases de données / Gestion 
653 |a Architecture client-serveur (Informatique) 
653 |a SQL server / fast 
653 |a SQL server / http://id.loc.gov/authorities/names/n90684343 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502 
653 |a COMPUTERS / Programming Languages / SQL. / bisacsh 
653 |a Database management / fast 
700 1 |a Coles, Michael 
700 1 |a Dye, David 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a The expert's voice in SQL server 
024 8 |a 10.1007/978-1-4302-3693-1 
776 |z 9781430236948 
776 |z 1430236930 
776 |z 1430236949 
776 |z 9781430236931 
776 |z 9781430236924 
776 |z 1430236922 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781430236924/?ar  |x Verlag  |3 Volltext 
082 0 |a 658 
082 0 |a 005.3/76 
520 |a 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 company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates anunprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source. Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers. Helps you design and develop robust, efficient, scalable ETL solutions Walks you through using the built-in, stock components Shows how to programmatically extend the power of SSIS to cover any possible scenario