Professional Microsoft SQL Server 2012 Integration Services

Brian Knight 지음

Wrox 2012년 03월 14일 출간

작품소개

책소개

An in-depth look at the radical changes to the newest release of SISSMicrosoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.Details the newest features of the 2012 SISS product release, which is the most significant release since 2005 Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.

목차

INTRODUCTION xxixCHAPTER 1: WELCOME TO SQL SERVER INTEGRATION SERVICES 1SQL Server SSIS Historical Overview 2What&-s New in SSIS 2Tools of the Trade 2Import and Export Wizard 3The SQL Server Data Tools Experience 4SSIS Architecture 5Packages 5Control Flow 6Data Flow 9Variables 13Parameters 14Error Handling and Logging 14Editions of SQL Server 14Summary 15CHAPTER 2: THE SSIS TOOLS 17Import and Export Wizard 17SQL Server Data Tools 23Creating Your First Package 25The Solution Explorer Window 26The Toolbox 27The Properties Windows 28The SSIS Package Designer 28Control Flow 29Connection Managers 32Variables 32Data Flow 34Parameters 34Event Handlers 34Package Explorer 35Executing a Package 36Management Studio 36Summary 37CHAPTER 3: SSIS TASKS 39SSIS Task Objects 40Using the Task Editor 40The Task Editor Expressions Tab 40SSDTCommon Properties 41Looping and Sequence Tasks 42Script Task (.NET) 43Analysis Services Tasks 45Analysis Services Execute DDL Task 45Analysis Services Processing Task 46Data Mining Query Task 46Data Flow Task 47Data Preparation Tasks 48Data Profi ler 48File System Task 50Archiving a File 52FTP Task 53Getting a File Using FTP 54Web Service Task 55Retrieving Data Using the Web Service Task and XML Source Component 57XML Task 60Validating an XML File 62RDBMS Server Tasks 64Bulk Insert Task 64Using the Bulk Insert Task 67Execute SQL Task 68Workfl ow Tasks 80Execute Package Task 80Execute Process Task 81Message Queue Task 82Send Mail Task 83WMI Data Reader Task 84WMI Event Watcher Task 86Polling a Directory for the Delivery of a File 86SMO Administration Tasks 87Transfer Database Task 88Transfer Error Messages Task 89Transfer Logins Task 89Transfer Master Stored Procedures Task 90Transfer Jobs Task 91Tran

작가정보

저자(글) Brian Knight

저자 :

저자 :

저자 :

저자 :

저자 :
저자 :
저자 :
Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com. Erik Veerman is a consultant, author, trainer, and a mentor with SolidQ. His award-winning industry recognition includes Microsoft's BI Solution of the Year and SQL Server Magazine's Innovator Cup.Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries.Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. He has co-authored several business intelligence books and regularly speaks at SQL events.Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software.