Professional Microsoft SQL Server 2014 Integration Services

Brian Knight 지음

Wrox 2014년 04월 17일 출간

작품소개

책소개

Fill the gap between planning and doing with SSIS 2014The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage.Implement new best practices for effective use of SSISWork through tutorials for hands-on learning of complex techniquesRead case studies that illustrate the more advanced conceptsLearn directly from the foremost authority on SSISSQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

목차

Introduction xxviiChapter 1: Welcome to SQL Server Integration Services 1SQL Server SSIS Historical Overview 2What&'s New in SSIS 2Tools of the Trade 3Import and Export Wizard 3The SQL Server Data Tools Experience 4SSIS Architecture 5Packages 5Control Flow 5Data Flow 9Variables 14Parameters 14Error Handling and Logging 14Editions of SQL Server 14Summary 15Chapter 2: The SSIS Tools 17Import and Export Wizard 17SQL Server Data Tools 24The Solution Explorer Window 26The SSIS Toolbox 27The Properties Windows 28The SSIS Package Designer 28Control Flow 29Connection Managers 32Variables 33Data Flow 34Parameters 35Event Handlers 35Package Explorer 36Executing a Package 37Management Studio 37Summary 37Chapter 3: SSIS Tasks 39SSIS Task Objects 40Using the Task Editor 40The Task Editor Expressions Tab 41Looping and Sequence Tasks 41Script Task (.NET) 41Analysis Services Tasks 44Analysis Services Execute DDL Task 44Analysis Services Processing Task 44Data Mining Query Task 46Data Flow Task 47Data Preparation Tasks 48Data Profiler 48File System Task 50Archiving a File 52FTP Task 53Getting a File Using FTP 54Web Service Task 56Retrieving Data Using the Web Service Task and XML Source Component 59XML Task 62Validating an XML File 64RDBMS Server Tasks 66Bulk Insert Task 66Using the Bulk Insert Task 69Execute SQL Task 71Workflow Tasks 82Execute Package Task 82Execute Process Task 84Message Queue Task 86Send Mail Task 87WMI Data Reader Task 88WMI Event Watcher Task 91Polling a Directory for the Delivery of a File 91

작가정보

저자(글) Brian Knight

저자 :

저자 :

저자 :

저자 :

저자 :
Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com.Devin Knight is a SQL Server MVP, the Training Director at Pragmatic Works, and an author on six SQL Server books.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, 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.Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.