LEADER 05424nam 2200685Ia 450 001 9910453198903321 005 20200520144314.0 010 $a1-118-05956-5 010 $a1-281-83701-6 010 $a9786611837013 010 $a0-470-41768-4 035 $a(CKB)1000000000552475 035 $a(EBL)366732 035 $a(OCoLC)431903051 035 $a(SSID)ssj0000341856 035 $a(PQKBManifestationID)11284341 035 $a(PQKBTitleCode)TC0000341856 035 $a(PQKBWorkID)10395357 035 $a(PQKB)10920750 035 $a(MiAaPQ)EBC366732 035 $a(CaSebORM)9780470247952 035 $a(Au-PeEL)EBL366732 035 $a(CaPaEBR)ebr10257608 035 $a(CaONFJC)MIL183701 035 $a(EXLCZ)991000000000552475 100 $a20080604d2008 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aProfessional SQL Server 2008 integration services$b[electronic resource] /$fBrian Knight ... [et al.] 205 $a1st edition 210 $aIndianapolis, IN $cWiley Pub.$dc2008 215 $a1 online resource (1010 p.) 225 1 $aWrox professional guides 300 $aIncludes index. 300 $a"Wrox programmer to programmer." 311 $a0-470-24795-9 327 $aProfessional SQL Server 2008 Integration Services; About the Authors; Credits; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; 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; SQL Server SSIS Historical Overview; What's New in SSIS; Getting Started; Architecture; Precedence Constraints; Containers; Variables; Data Flow Elements; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard 327 $aBusiness Intelligence Development StudioCreating Your First Package; The Solution Explorer Window; The SSIS Package Designer; Package Installation Wizard; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Looping and Sequence Tasks; Scripting Tasks; Analysis Services Tasks; Data Flow Task; Data Preparation Tasks; RDBMS Server Tasks; Workflow Tasks; SMO Administration Tasks; Summary; Chapter 4: Containers; Task Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Summary; Chapter 5: The Data Flow; The Data Flow; Data Viewers; Sources 327 $aDestinationsTransformations; Data Flow Example; Summary; Chapter 6: Using Expressions and Variables; The Paradigm; Understanding Data Types; Using Variables; Working with Expressions; Summary; Chapter 7: Joining Data; The Lookup Component; The Merge Join Component; Contrasting to the Relational Join; New Lookup Features; Building the Basic Package; Using the Lookup Component; Cache Connection Manager and Transform; Summary; Chapter 8: Creating an End-to-End Package; Basic Transformation Tutorial; Typical Mainframe ETL with Data Scrubbing; Looping and the Dynamic Task; Summary 327 $aChapter 9: Scripting in SSISScripting?; Getting Started in SSIS Scripting; Using the Script Task; Using the Script Component; Essential Coding, Debugging, and Troubleshooting Techniques; Summary; Chapter 10: Loading a Data Warehouse; Data Profiling; Data Extraction; Dimension Table Loading; Fact Table Loading; SSAS Processing; Master ETL Package; Summary; Chapter 11: Using the Relational Engine; Data Extraction; SQL Server 2008 Change Data Capture; Data Loading; Summary; Chapter 12: Accessing Heterogeneous Data; Excel and Access; Oracle; XML and Web Services; Flat Files; ODBC 327 $aOther Heterogeneous SourcesSummary; Chapter 13: Reliability and Scalability; Restarting Packages; Package Transactions; Error Outputs; Scaling Out; Summary; Chapter 14: Understanding and Tuning the Data Flow Engine; The SSIS Engine; SSIS Data Flow Design and Tuning; Pipeline Performance Monitoring; Summary; Chapter 15: Source Control and Software Development Life Cycle; Introduction to Software Development Life Cycles; Versioning and Source Code Control; Code Deployment and Promotion from Development to Test to Production; Summary; Chapter 16: DTS 2000 Migration 327 $aManaging DTS 2000 Packages within SQL Server Management Studio 330 $aThe new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than everCase studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniquesNew chapters include coverage of data warehousing using SSIS, new me 410 0$aWrox professional guides. 606 $aDatabase management 608 $aElectronic books. 615 0$aDatabase management. 676 $a005.75/85 676 $a005.7585 701 $aKnight$b Brian$f1976-$025445 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910453198903321 996 $aProfessional SQL Server 2008 integration services$92045575 997 $aUNINA