Benutzerdefiniertes Cover
Professional Microsoft SQL Server 2014 Integration Services / Brian Knight ...
Mitwirkende(r): Resource type: Ressourcentyp: Buch (Online)Buch (Online)Sprache: Englisch Verlag: Hoboken : Wiley, 2014Beschreibung: Online-Ressource (916 p)ISBN:- 9781118850909
- 9781306638890
- 1306638895
- 9781118850909
- 9781118850879
- 005.8
- 005.7585
- QA76.9.D3
- QA76.9.D3 .K384 2014
Inhalte:
Zusammenfassung: Fill the gap between planning and doing with SSIS 2014 The 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 MPPN: PPN: 1657629090Package identifier: Produktsigel: ZDB-26-MYL | ZDB-30-PQE
Professional Microsoft® SQL Server® 2014 Integration Services; Copyright; About the Authors; About The Technical Editor; 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; Tools of the Trade; Import and Export Wizard; The SQL Server Data Tools Experience; SSIS Architecture; Packages; Control Flow; Data Flow; Variables; Parameters
Error Handling and LoggingEditions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard; SQL Server Data Tools; The Solution Explorer Window; The SSIS Toolbox; The Properties Windows; The SSIS Package Designer; Control Flow; Connection Managers; Variables; Data Flow; Parameters; Event Handlers; Package Explorer; Executing a Package; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Using the Task Editor; The Task Editor Expressions Tab; Looping and Sequence Tasks; Script Task (.NET); Analysis Services Tasks; Analysis Services Execute DDL Task
Analysis Services Processing TaskData Mining Query Task; Data Flow Task; Data Preparation Tasks; Data Profiler; File System Task; Archiving a File; FTP Task; Getting a File Using FTP; Web Service Task; Retrieving Data Using the Web Service Task and XML Source Component; XML Task; Validating an XML File; RDBMS Server Tasks; Bulk Insert Task; Using the Bulk Insert Task; Execute SQL Task; Workflow Tasks; Execute Package Task; Execute Process Task; Message Queue Task; Send Mail Task; WMI Data Reader Task; WMI Event Watcher Task; Polling a Directory for the Delivery of a File
SMO Administration TasksTransfer Database Task; Transfer Error Messages Task; Transfer Logins Task; Transfer Master Stored Procedures Task; Transfer Jobs Task; Transfer SQL Server Objects Task; Summary; Chapter 4: The Data Flow; Understanding the Data Flow; Data Viewers; Sources; OLE DB Source; Excel Source; Flat File Source; Raw File Source; XML Source; ADO .NET Source; Destinations; Excel Destination; Flat File Destination; OLE DB Destination; Raw File Destination; Recordset Destination; Data Mining Model Training; DataReader Destination; Dimension and Partition Processing
Common TransformationsSynchronous versus Asynchronous Transformations; Aggregate; Conditional Split; Data Conversion; Derived Column; Lookup; Row Count; Script Component; Slowly Changing Dimension; Sort; Union All; Other Transformations; Audit; Character Map; Copy Column; Data Mining Query; DQS Cleansing; Export Column; Fuzzy Lookup; Fuzzy Grouping; Import Column; Merge; Merge Join; Multicast; OLE DB Command; Percentage and Row Sampling; Pivot Transform; Unpivot; Term Extraction; Term Lookup; Data Flow Example; Summary; Chapter 5: Using Variables, Parameters, and Expressions
Dynamic Package Objects
Dieser Titel hat keine Exemplare