Contents
Chapter 1: Metadata Collection
sys.dm_os_performance_counters
Setting Up the Central Repository
Building the Demonstration SSIS Package
The SQL Server 2014 Integration Services Service
Integration Server Catalog Stored Procedures
Scheduling SSIS Package Execution
Scheduling a File System Package
Running SQL Server Agent Jobs with the Custom Execution Framework
Running the Custom Execution Framework with SQL Server Agent
Connection Managers and Scripting
Chapter 4: SQL Server Source Patterns
Selecting a SQL Server Connection Manager and Provider
Creating a SQL Server Source Component
Writing a SQL Server Source Component Query
Chapter 5: Data Correction with Data Quality Services
Overview of Data Quality Services
Cleansing Data in the Data Flow
Handling the Output of the DQS Cleansing Transform
Approving and Importing Cleansing Rules
Chapter 6: DB2 Source Patterns
DB2 Source Component Parameters
DB2 Source Component Dynamic Queries
Chapter 7: Flat File Source Patterns
Introducing a Data-Staging Pattern
Chapter 8: Loading a PDW Region in APS
DWLoader vs. Integration Services
Making Things Easier with XSLT
Configuring the Script Component
Processing XML with XmlSerializer
Processing XML with XmlReader and LINQ to XML
Chapter 10: Expression Language Patterns
Getting to Know the Expression Language
What Is the Expression Language?
Putting the Expression Language to Work
Project-Level Connection Managers
Chapter 11: Data Warehouse Patterns
Incremental Loads of Fact Data
The Slowly Changing Dimension Wizard
One Package = One Unit of Work
Understanding the OData Protocol
Configuring the OData Connection Manager
Enabling Microsoft Online Services Authentication
Configuring the Source Component
Chapter 13: Slowly Changing Dimensions
The Slowly Changing Dimension Transform
Incremental Loads to Azure SQL Database
Chapter 15: Logging and Reporting Patterns
Design Pattern: Package Executions
Changing Logging Levels After the Fact
Chapter 16: Parent-Child Patterns
Child-to-Parent Variable Pattern
Configuring Your Package Using Parameters
Creating Visual Studio Configurations
Specifying Entry-Point Packages
Parameter Configuration on the Server
Default Parameter Values Using T-SQL
Package Execution Through the SSIS Catalog
Configuring from a Database Table
Setting Values Using a Script Task
Deployment from the Command Line
Chapter 19: Business Intelligence Markup Language
A Brief History of Business Intelligence Markup Language
Building a Basic Incremental Load SSIS Package
Using Biml as an SSIS Design Patterns Engine
Chapter 20: Biml and SSIS Frameworks
Using Biml with an SSIS Framework
Adding SSIS Package Metadata to the Framework
Generating the SSIS Command-Line
Appendix A: Evolution of an SSIS Framework
Retrieving SSIS Applications in T-SQL
Retrieving SSIS Applications in SSIS
Building Application Instance Logging
3.137.160.131