Cargando…

Professional SQL server 2005 integration services /

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scrip...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Otros Autores: Knight, Brian, 1976-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Wiley, ©2006.
Colección:Wrox professional guides.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000Ia 4500
001 OR_ocm76788927
003 OCoLC
005 20231017213018.0
006 m o d
007 cr zn|||||||||
008 061122s2006 inua o 001 0 eng d
010 |a  2005026347 
040 |a NTG  |b eng  |e pn  |c NTG  |d N$T  |d YDXCP  |d IDEBK  |d E7B  |d OCLCQ  |d UMI  |d OCLCQ  |d B24X7  |d REDDC  |d OCLCQ  |d DEBSZ  |d OCLCF  |d OCLCQ  |d EBLCP  |d OCLCQ  |d COO  |d OCLCQ  |d LIV  |d OCLCQ  |d OCLCO  |d CEF  |d WYU  |d UAB  |d AU@  |d OCLCQ  |d VT2  |d RDF  |d OCLCQ  |d OCLCO  |d UKAHL  |d OCLCQ  |d OCLCO 
015 |a GBA588745  |2 bnb 
016 7 |z 013316073  |2 Uk 
019 |a 156819303  |a 159934547  |a 646798782  |a 741113011  |a 1064763936  |a 1103268766  |a 1129372950  |a 1153038508  |a 1192336718  |a 1240524627 
020 |a 9780471789697  |q (electronic bk.) 
020 |a 0471789690  |q (electronic bk.) 
020 |z 9780764584350  |q (paper/website) 
020 |z 0764584359  |q (paper/website) 
029 1 |a AU@  |b 000053225130 
029 1 |a DEBSZ  |b 368472078 
029 1 |a AU@  |b 000062640299 
029 1 |a AU@  |b 000069008120 
035 |a (OCoLC)76788927  |z (OCoLC)156819303  |z (OCoLC)159934547  |z (OCoLC)646798782  |z (OCoLC)741113011  |z (OCoLC)1064763936  |z (OCoLC)1103268766  |z (OCoLC)1129372950  |z (OCoLC)1153038508  |z (OCoLC)1192336718  |z (OCoLC)1240524627 
037 |a CL0500000098  |b Safari Books Online 
050 4 |a QA76.9.D3  |b P767 2006eb 
072 7 |a COM  |x 018000  |2 bisacsh 
082 0 4 |a 005.75/85  |2 22 
049 |a UAMI 
245 0 0 |a Professional SQL server 2005 integration services /  |c Brian Knight [and others]. 
260 |a Indianapolis, Ind. :  |b Wiley,  |c ©2006. 
300 |a 1 online resource (xxviii, 692 pages) :  |b illustrations. 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Wrox professional guides 
505 0 |a Professional SQL ServerTM 2005 Integration Services; About the Authors; Acknowledgments; Contents; Foreword; Introduction; Who This Book Is For; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1 Welcome to SQL Server Integration Services; What's New in SQL Server 2005 SSIS; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server 2005; Summary; Chapter 2 The SSIS Tools; Import and Export Wizard; Package Installation Wizard 
505 8 |a Business Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Summary; Chapter 3 SSIS Tasks; Shared Properties; Execute SQL Task; Bulk Insert Task; Using the Bulk Insert and Execute SQL Tasks; Data Flow Task; Execute Process Task; File System Task; FTP Task; Using the File System and FTP Task; Execute Package Task; Script and ActiveX Tasks; Send Mail Task; Message Queue Task; Web Service Task; WMI Data Reader and Event Watcher Task; XML Task; SQL Server Analysis Services Execute DDL and Processing Tasks; Data Mining Query Task 
505 8 |a The Expression PageSummary; Chapter 4 Containers and Data Flow; Containers; Sources; Destinations; Transformations; Data Flow Example; Data Viewers; Summary; Chapter 5 Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary; Chapter 6 Advanced Tasks and Transforms; Execute SQL Task; Import Column; Using Temp Tables in SSIS Package Development; Export Column; Row Count; OLE DB Command; Term Extraction; Term Lookup; Fuzzy Lookup; Fuzzy Grouping; Pivot Transform; Unpivot; Slowly Changing Dimension 
505 8 |a Database Object-Level TasksSummary; Chapter 7 Scripting in SSIS; Scripting Overview; Expressions; Script Tasks; Using .NET Assemblies; Structured Exception Handling; Script Component; Summary; Chapter 8 Accessing Heterogeneous Data; Excel; Access; Oracle; Web Services; XML Data; Summary; Chapter 9 Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 10 Understanding the Integration Services Engine; The Integration Services Engine: An Analogy; Understanding the SSIS Data Flow and Control Flow 
505 8 |a Enterprise Workflows with the Control FlowEnterprise Data Processing with the Data Flow; Summary; Chapter 11 Applying the Integration Services Engine; That Was Then: DTS; This Is Now: Integration Services; Pipeline Performance Monitoring; Summary; Chapter 12 DTS 2000 Migration and Metadata Management; Migrating DTS 2000 Packages to SSIS; Using the Package Migration Wizard; Running DTS 2000 Packages under SSIS; Package Metadata and Storage Management; Summary; Chapter 13 Error and Event Handling; Precedence Constraints; Event Handling; Breakpoints; Checkpoints; Logging; Summary 
520 |a This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language. What you will learn from this bookWays to quickly move and transform dataHow to configure every aspect of SSISHow to interface SSIS with web services and XMLTechniques to scale the SSIS and make it more r. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a SQL server. 
630 0 7 |a SQL server.  |2 blmlsh 
630 0 7 |a SQL server  |2 fast 
650 0 |a Database management. 
650 6 |a SQL Server. 
650 6 |a Bases de données  |x Gestion. 
650 7 |a COMPUTERS  |x Data Processing.  |2 bisacsh 
650 7 |a Database management  |2 fast 
700 1 |a Knight, Brian,  |d 1976- 
776 0 8 |i Print version:  |t Professional SQL server 2005 integration services.  |d Indianapolis, IN : Wrox/Wiley Pub., ©2006  |z 0764584359  |z 9780764584350  |w (DLC) 2005026347  |w (OCoLC)61479606 
830 0 |a Wrox professional guides. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780764584350/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a Askews and Holts Library Services  |b ASKH  |n AH13384602 
938 |a Books 24x7  |b B247  |n bks00005438 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL3056899 
938 |a ebrary  |b EBRY  |n ebr10278122 
938 |a EBSCOhost  |b EBSC  |n 197934 
938 |a YBP Library Services  |b YANK  |n 2605977 
994 |a 92  |b IZTAP