ADO.NET

    connection manager

    integration server catalog stored procedures

    providers

    script task

    source component query

American Standard Code for Information Interchange (ASCII)

Application Instance logging

    failures

    instance tables and stored procedures

    logged results

    parent package and event handler

    SSIS application and package

    unit-testing

Application monitoring. See Monitoring execution

Brute force detection

Business Intelligence Markup Language (BIML)

    file

        connect metadata

        error message

        metadata

        SSIS package

        TestBimlPackage.dtsx

        XML metadata

    history

    incremental load pattern

        add metadata

        BIML testing

        data flow task

        test databases and tables

        transformations

    SSIS design patterns engine

    testing BIML file

Catalog logging

    built-in reports

        integration services dashboard

        package execution report

    change

    design patterns

        level changes

        report creation

        utilization reports

    logging level eliminates

    setting up

    SSIS

        levels

        views

    SSISDB

    tables

Change data capture (CDC)

    detection

        brute force

        checksum-based detection

        detection via hashbytes

    DML operations

    historical data

    incremental loads

    integration services

    log sequence number (LSN)

    usage

Checksum-based detection

Cloud technology

    incremental loads

        block diagram

        detection

        new rows

    interact

    loader

Command-line execution

Connection manager

    design patterns, script

        objects

        script component

        script task

    DQS

    expression language patterns

    flat file sources

    metadata collection framework

    objects

    OLE DB

    parameter model

    script component, XML configuration

    scripting patterns, design

    script task

    SQL Server source patterns

        ADO.NET

        ODBC

        OLE DB

        types

    window provider list, DB2 database

Customer Service and Support (CSS)

Custom logging

Database table

    configuration

    creation

    Execute SQL Task

Data definition language (DDL)

Data flow cleansing

    issues

    output handling, DQS cleansing transform

        column status values

        conditional split transformation

        processing logic

    parallel processing

    row filtering, with Lookup Transforms

        column mapping

        completed data flow, pre-filter rows

        pattern

    row tracking

Data Quality Client application

    administration section

    default knowledge base

    DQS roles

    knowledge base management

        activities

        domain management

    online RDS

    projects

Data Quality Services (DQS)

    cleansing rules

    cleansing transformation editor

        additional columns

        advanced tab

        cleansing rules

        data flow toolbox

        log messages

        standardization

    components

    data flow cleansing

        issues

        output handling, DQS Cleansing transform

        parallel processing

        row filtering, with Lookup Transforms

        row tracking

    Data Quality Client application

        administration section

        default knowledge base

        knowledge base management

        online RDS

        projects

    domains

    roles

    with SSIS

        cleansing transform editor

        composite domains

        connection manager

        data flow toolbox

        mapping tab

Data taps

Data Transformation Services (DTS)

Data translations

Data warehouse patterns

    coding errors

        cleanup

        failure

        meaning

        SQL transactions

        SSIS transactions

        unhandled errors

    data errors

    ETL workflow

        one package = one unit

        work division

    incremental load

        fact data

        meaning

        slowly changing dimension

        systematic identification

    missing data

        add dimension member

        dimension members

        loading dimensions

        triage table

    simple errors

DB2 database

    connection manager window provider list

    data link properties window, with Host CCSID list

    encoding schemes

    family

        AS/400, iSeries, System I, and Power Systems

        Linux, UNIX, and Windows (LUW) version

        z/OS platform

    query

        source component dynamic queries

        source component parameters

    Source Assistant, source window

Debug execution

Deployment models

    execution patterns (see Execution patterns)

    Integration Services Deployment Wizard command line parameters

    methods

        command line

        using custom code

        using PowerShell

        using SQL

    package deployment model

        conversion

        deployment locations

    project deployment model

    SSIS catalog

        deployment wizard status page

        descritpion

        Integration Services Deployment Wizard

Design patterns.

    catalog logging and reporting

        logging levels

        report creation

        types

        utilization reports

    package logging and reporting

    script

        connection managers

        naming patterns

        variables

DTEXEC

    description

    file system projects

    SSIS catalog projects

Dynamic management functions (DMFs)

Dynamic management views (DMVs)

Entry-point packages

Error logging

    bubble event

    error metadata

    execute SQL task editor

    parameters

    ReadOnlyVariables property

    script task

    SSIS

        framework events

        task

    SSISConfig database

Event and error logging. See Logging patterns

Execute package utility

Execute SQL Task editor

    metadata collection

    parameter mapping

Execution patterns

    managed code

        demo application

        frmMain form

    metadata-driven execution

    SSIS packages

        command-line execution

        Custom Execution Framework, with SQL Agent

        debug execution

        execute package utility

        file system package schedule

        integration server catalogs

        integration server catalog stored procedures

        schedule

        SQLAgent Jobs, with custom execution framework

Expression language patterns

    assignment

    connection managers

    control flow

        constraints

        editor

        non-standard notation

        precedence constraints

        tasks and containers

    C-style languages

    custom task/component

    data flow

        branches

        business rules

        data cleansing

        multiple paths

    data source component

    definition

    evaluation

    Execute SQL Task

    functional domains

    limitations

    package level

    project connection managers

    script task and component

    third party task/component

    tools

    T-SQL

    use of

    variables

Expressions, parameter model

    expressionable data flow component properties

    property expressions editor

    variables, Expression Builder dialog

    variables window

Extended Binary Coded Decimal Interchange Code (EBCDIC)

Extract, transform and load (ETL) projects

    communication

    estimation

    measurement

    processes

    technology

    timelines

        elements

        experience

        personalities

        schedule

        unexpectation

File connection manager

    parent-child pattern

    XML configuration

File system package

Flat file sources

    archive file pattern

        error message

        parameters

        script

        source/destination

        SSIS package

        steps

        variables and parameters

        VSTA projects script editor

    data types

    demo project

    derived column transformation

    footer row

        consume

        meaning

        produce

    header row

        consume

        meaning

        produce

    SSIS

        columns page

        configuration

        connection manager page

    staging data

        auto-mapping

        data flow task

        ETL developer

        input-to-output mappings

        metadata page

        overwritting

        T-SQL DDL statement

    variable-length row

        CSV and TDF

        data flow

        script component, termination

        splitting record types

        stream termination

Footer row, flat files

    consume

        columns page

        configuration

        debugg

        row count and extract date

    meaning

    produce

        class and variable declaration

        execution

        mapping package parameters

        parameters

        SSIS package

        test package

        variables

Foreach Loop editor

Header row, flat files

    consume

        debugg

        Input0_ProcessInputRow

        source file

    meaning

    produce

        bindings page

        data flow tasks

        dynamic connectionString properties

        execution

        parameters

IBM OLE DB provider

Integration server catalogs

Knowledge base management

    activities

    domain management

LINQ to XML functionality

Logging patterns

    essentials

        capturing data patterns

        elements

        error and events

        ETL domain

    SSIS

        capture data

        catalog

        custom logging

        logging platforms

        package-levels

        package logging

Managed code execution

    demo application

    frmMain form

        btnStartFileClick subroutine

        code

        ISTree form

        layout

        package selection and execution

        SSIS catalog representation

        SSISDB

Management Object Model (MOM)

    custom code

    PowerShell

Massively parallel processing (MPP)

Merge Join transform

MERGE pattern, SCD

    control flow

    steps

    Type 1 changes

    Type 2 changes

Metadata collection

    central repository set up

    current data and log file sizes retrieval

    Data Flow task

    DBA

    dba_monitor_unusedIndexes table creation

    dbaToolBox

    description

    DMFs

    DMVs

    framework

        connection manager

        dynamic connection properties

        editing, result set

        Execute SQL Task Editor

        Foreach Loop Container

        Foreach Loop Editor

        new integration services project

        package-scoped variables

        Property Expressions Editor

        Retrieve SQL Server Instances statement

        variable mappings

        variables menu

    Integration Services package

    Mappings page

    OLE DB

        destination connection manager

        destination mappings

        Source editor

    package execution

    parameter mapping

    SQL Server

        catalogs

        Management Studio 2012

        metadata

    SSDT

    table creation

    Unused Indexes retrieval

Metadata-driven execution

Microsoft OLE DB provider

MOM. See Management Object Model (MOM)

Monitoring execution

    application instance logging

        failures

        instance tables and stored procedures

        logged results

        OnError event handler

        parent package and event handler

        SSIS application and package

        Sub Main()

        unit-testing

    error logging

        bubble event

        error metadata

        execute SQL task editor

        framework events

        parameters

        ReadOnlyVariables property

        script task

        SSISConfig database

        task

    Log.SSISAppInstance and Log.SSISPkgInstance

    package instance logging

        log.SSISPkgInstance table

        parameters

        Parent.dtsx

        table and stored procedures

        test executions

Naming patterns, script

OLE DB

    command transforms

    connection manager

    destination

        connection manager

        mappings

    source component query

    Source editor

Online Reference Data Services (RDS)

Open database connectivity (ODBC)

Package-application relationships

    Cfg.AppPackages and Cfg.AddSSISApplicationPackage

    coupling method

    mappings

    T-SQL script

Package deployment model

    conversion

    deployment locations

Package logging

    instance logging

        log.SSISPkgInstance table

        parameters

        Parent.dtsx

        table and stored procedures

        test executions

    reporting method

        design patterns

        log information

        results

        set up logging

        SSIS logging menu

        SSIS log table

    SSIS

Package-scoped variables

Parallel Data Warehouse (PDW)

    architecture overview

    BIDS

    data destination

        connection

        editor

        loading modes

        modal

        multi-threading

        Nexus query tool

        replicated and distributed tables

        roll-back load

        SQL Server

        staging database

    data flow

        data source

        destination

        OLE DB source editor

        transformation

    data source

    destination adapter installation

    DWLoader vs. integration services

    ETL vs. ELT

    scan

    shared-nothing architecture

    SMP and MPP

Parameter model

    configuration

        default configuration

        package execution, SSIS catalog

        parameter values using T-SQL

        server environments

    connection managers

    description

    DTEXEC

        description

        file system projects

        SSIS catalog projects

    dynamic configurations

        database table

        dynamic package executions

        script task

    entry-point packages

    expressions

        expressionable data flow component properties

        property expressions editor

        variables, Expression Builder dialog

        variables window

    package level parameters

    project level parameters

    UI parametrization

    Visual Studio configurations

        Configuration Manager dialog

        description

        development

        manage parameter values dialog

Parent-child patterns

    add packages

    cfg.Packages

    cfg Schema and cfg.Packages table

    child-parent variable pattern

    conversion

    dynamic child package

        create and insert statements

        execution page

        expressions screen

        foreach loop editor screen

    execution

    expression textbox

    master package

        child package

        parameter binding configuration

        parent package

    message box

    package deployment model

    SSISConfig database

    stored procedure

    Sub Main()

    T-SQL script

Project deployment model

Property Expressions editor

Reporting patterns. See also Logging patterns

    catalog logging

        change

        design patterns

        setting up

        tables

    package method

        design patterns

        log information

        results

        set up logging

        SSIS logging menu

        SSIS log table

Script components

    configuration, XML

        connection manager

        file connection manager

        output columns

        script component patterns code

        script component source creation

    connection managers

    external assemblies

    LINQ to XML functionality

    types of modes

    uses

Scripting patterns

    design

        connection managers

        naming patterns

        variables

    DTS

    maintenance

        code reuse

        copy/paste

        custom tasks/components

        external assemblies

        source control

    script component

        configuration

        types of modes

        uses

    script editor

        compiler

        Full .NET runtime

        project explorer

    script task

        configuration

        requirements

    toolset

Script maintenance patterns

    code reuse

    copy/paste

    custom tasks/components

    external assemblies

    source control

Script task

    compilation error

    configuration

    dynamic configurations

    external assemblies

    project explorer

    project properties

    requirements

Service level agreements (SLAs)

Slowly changing dimensions (SCDs)

    disadvantages

    elements

    incremental load

    key scenarios

    MERGE pattern

        control flow

        steps

        Type 1 changes

        Type 2 changes

    OLE DB

        command transforms

        destination

    output result

    performance

    processing patterns

    third party components

    using transformations

    wizard

        column change types

        dimension table and keys selection

        fixed and changing attribute options

        historical attribute options

        inferred dimension members

Source Assistant, SQL Server

Source editor, XML

    attributes

    customers database table schema

    element/sub-element structure

    IsSorted property value setting

    Merge Join transform

    outputs and column names generation

    SortKeyPosition property value setting

    XSLT

        script

        simplified XML document

        XML task configuration

Source patterns, DB2

    database

        connection manager window provider list

        data link properties window, with Host CCSID list

        encoding schemes

        family

        query

        Source Assistant, source window

    IBM OLE DB provider

    Microsoft OLE DB provider

    provider

        find database version

        pick provider vendor

Source patterns, SQL Server

    connection manager

        ADO.NET

        ODBC

        OLE DB

        types

    set up

    source component

        data flow task

        OLE DB Source editor screen

        SSIS toolbox

    source component query

        ADO.NET

        data translations

        OLE DB

        waste not, want not

SQL Server Data Tools (SSDT)

SQL Server Integration Services (SSIS)

    applications

        add data

        cfg.Applications and cfg.AddSSISApplication

        execution

        T-SQL

        variable window

    capture data

    catalog

        built-in reports

        logging levels eliminates

        SSISDB

    change data capture

        detection

        historical data

        incremental loads

        integration services

        usage

    command-line execution

    custom execution framework, with SQL Agent

        description

        execute package task reference property

        project reference package

    custom logging

    debug execution

    deployment models catalog

        deployment wizard status page

        descritpion

        Integration Services Deployment Wizard

    DQS

        cleansing transform editor

        composite domains

        connection manager

        data flow toolbox

        mapping tab

    ETL logging systems

    execute package utility

    execution schedule

    file system package schedule

    integration server catalog stored procedures

        ADO.NET connection

        Connection property

        custom execution framework creation

        data taps

        package execution twice

        parameter mapping page

        parent package control flow

        Result Set page

        Transact-SQL Script

        variable mappings page

        wrapper stored procedure script

    logging platforms

    lookup caching options

        load staging

        table

        transformation and connection manager

    managed code

        demo application

        frmMain form

    merge statement

        action

        audit table

        control flow design pattern

        insert, update and delete

    metadata-driven execution

    monitoring execution

        application instance logging

        error logging

        package instance logging

    native components

        design pattern

        operations

        useful and mature

    package-application relationships

        Cfg.AppPackages and Cfg.AddSSISApplicationPackage

        coupling method

        mappings

        T-SQL script

    package logging

    parent-child pattern

        add packages

        cfg.Packages

        cfg Schema and cfg.Packages table

        conversion

        execution

        expression textbox

        file connection manager

        message box

        package deployment model

        SSISConfig database

        stored procedure

        Sub Main()

        T-SQL script

    SCD

        disadvantages

        elements

        output result

        wizard

    SQLAgent Jobs, with Custom Execution Framework

    tools and methodologies

SQL Server Management Studio (SSMS)

SQL Server Reporting Services (SSRS)

    application instance data

    Application Name

    color

    dataset

    error

    error log data

    events hyperlink

    expression

    failed hyperlinks

    final result

    new application

    Package Instance report

    report preview

    report wizard

    rpt.ReturnEvents

    Rpt Schema and Rpt.ReturnAppInstanceHeader

    shared data source

    status and packages decoration

    updation

SSIS catalog database (SSISDB)

Symmetric multi-processing (SMP)

T-SQL

    Cfg.GetSSISApplication statement

    DDL script

    SSIS Packages

    stored procedure

User interface parametrization

Variables

    data types

    mapping

    syntax in code

    visibility

Visual Studio Configurations

    Configuration Manager dialog

    description

    development

    manage parameter values dialog

XML

    description

    script component

        configuration

        description

        XmlReader and LINQ to XML

        XmlSerializer

    source component

        attributes

        customers database table schema

        element/sub-element structure

        IsSorted property value setting

        Merge Join transform

        outputs and column names generation

        SortKeyPosition property value setting

        XSLT