Index

Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Previous Chapter

Appendix A: Evolution of an SSIS Framework

Index

A

AcquireConnection method

Advanced Editor

AndyWeather.com

B

Business intelligence (BI)

Business Intelligence Development Studio (BIDS)

Business Intelligence Markup Language (Biml)

data integration development

BimlScript.biml file

connect metadata

Execute SQL Task

TestBimlPackage.dtsx

incremental load pattern

databases and tables creation

debug executing script

dtsx SSIS package test script

pre-SSIS-package script

SSISIncrementalLoad_Source.dbo.tblSource

transforms (see Transforms)

T-SQL reset rows script

package metadata

FrameworkSQLGen.biml file

PackageName and ExecutionOrder

Transact-SQL script

SSIS design patterns engine

add .NET namespaces and initial method

connection variable

Execute SQL task

GenerateTableNodes() method

package node with .NET replacements

packages node and starting loop

SSISIncrementalLoad_Stage database

dynamic SSIS package

four SSIS packages

C

Catalog deployment model

Change data capture (CDC)

Child-to-Parent variable pattern

ADO.Net destination adapter

AWCleanLoadMaxID variable

CleanTemperature table

CleanTempLocalMaxID variable

dbo.CleanTemperature table

LoadMetrics table

OLE DB source adapter

WeatherData Source Query

Clustered columnstore index (CCI)

Command-line execution

Compilation error

Composite domain (CD)

Connection managers

DB2 source patterns

Data Link properties

OLE DB Provider

ADO.NET connection

connection object

script component

ConnectionString property

Customer Service and Support (CSS)

D

Data cleansing. See Data quality services (DQSs)

The Data Conversion Transformation Editor

Data Definition Language (DDL)

adding missing dimension member

unhandled errors

Data Quality services (DQSs)

cleansing transform

asynchronous component

column status value

Conditional Split transformation

Connection Manager

data flow logic processing

data flow toolbox

importing domain values

KB editor, corrections

list of columns

logs information

mapping tab, column selection

parallel processing

project name generation

right hand pane

rows filtering, Lookup transform

composite domains

data quality client

Administration section

data management

data quality project

default knowledge base

knowledge base management

online reference data

Data Transformation Services (DTSs)

Data warehouse patterns

data error (see Data error)

incremental loads (see Incremental loads)

DB2 source patterns

connection manager

Data Link properties

OLE DB Provider

database version

provider vendor

Derive Parameters property

Edit Property Value window

SQL PL and PL/SQL

Debug execution

Wizard command line

Package Deployment Model

Project Deployment Model

Deployment models. See Execution patterns

Domain management

Dynamic management functions (DMFs)

Dynamic management views (DMVs)

E

AppInstanceID and PkgInstanceID SSIS variables

build error logging table and stored procedure

ErrorDescription parameter

information event

Log Application Variables

Log.LogEvents table

Log Package Variables

log.SSISErrors table

Parameter Mapping page

Parent Package OnError event handler

SourceName and ErrorDescription

Execute Package Task Editor

Execute Package Utility (DtExecUI)

Execute SQL Task Editor

Execution patterns

command-line execution

custom execution framework, SQL Agent jobs

debug execution

Execute Package task

Execute Package Utility

file system package schedule

Integration Server catalogs (see Integration Server catalog)

Integration Services catalogs

managed code (see Managed code execution)

metadata-driven execution

Project Reference Package

Public Sub Main()

public void Main()

SQLAgent jobs, with custom execution framework

Expression language

connection managers

DATEPART function

dynamic file name

file-based sources

precedence constraints (see Precedence constraints)

C-style languages

custom task/component

data source component

Execute SQL task

Script component

SQL Server Data Quality Services/Master Data Services

third-party task/component

functional domains

maintenance scope

Extract, load, and transform (ELT) processes

Extract, transform, and load (ETL) process

F, G

Flat file source patterns

archive file pattern

Connection Manager Editor’s Columns page

data-staging pattern

CREATE TABLE Statement

data flow path editor

Modified CREATE TABLE Statement

OLE DB destination auto-mapping

editor connection manager configuration

Conditional Split transformation

FileInUse function

imports statement

Main() Subroutine

mapping package parameters

MyFileFooterSource.csv

row count and extract date

select variables

TestParent.dtsx package

WriteFileFooter.dtsx package

CreateNewOutputRows Subroutine

Dynamic ConnectionString property

Execute Package Task Editor

Input0_ProcessInputRow Subroutine

iRowNum Integer Variable

WriteFileHeader.dtsx

splitting record types

terminate streams

variable-length row flat file

Foreach Loop Editor

H

Hardware architecture

I, J

Incremental loads

brute force detection

checksum-based detection

Control task Editor

Hashbytes function

historical load

integration services

supply-side incremental load tool

table-by-table basis

MERGE Statement

control flow design

INSERT, UPDATE, and DELETE operations

ISNULL() function

SSIS load package

T-SQL MERGE functionality

native SSIS components

lookup operations

systematic identification

Integration Server catalog

custom execution framework

ADO.Net connection

Connection property

package execution twice

Parameter Mapping page

parent package control flow

Result Set page

T-SQL statements

Variable Mappings page

Flat File Connection manager

OLEDBDest TemperatureStage OLE DB destination adapter

wrapper-stored procedure script

SSISDB database

wrapper stored procedure script

Integration Services

K

Knowledge base management

Knowledge discovery

L

LoadPackage method

Logging and reporting patterns

existing reports

internal tables

levels changing

OnVariableValueChanged

Log sequence number (LSN)

Lookup transforms

M, N

Managed code execution

demo application

btnStartFileClick subroutine

frmISTreeHelper

frmMainHelper module

package execution

package selection

SSIS Catalog representation

Management Object Model (MOM)

Manage Parameter Values

Massively parallel processing (MPP)

Matching Policy activity

Metadata collection

central repository

dba_monitor_SQLServerInstances

server instance monitoring

current data and log file sizes retrieval

data storage and log file size information

dba_monitor_unusedIndexes table

Foreach Loop container

information retrieval

integration services package

iterative framework

Connection Manager

dynamic properties connection

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

SQL Task Editor

variable mappings

OLE DB destination connection manager

OLE DB Source Editor

package execution

parameter mapping

SQL server metadata catalog

stored procedure

Unused Indexes Retrieval

Update LastMonitored Value

Metadata-driven execution

Microsoft Azure SQL Database (MASD)

AndyWeather database

change detection

My Flat File connection manager

O

OData Connection Manager Editor

OData Source Editor

Command transforms

Open Data (OData) protocol

Advanced Editor

Connection Manager

default data types

EDM data type mapping

metadata document

Microsoft online services authentication

P, Q

Package deployment model

Parallel Data Warehouse (PDW)

hardware architecture

shared-nothing architecture

software architecture

compression estimation

Data Conversion

data import pattern

Destination Database, PDW code

FactSales table

OLE DB Source Editor

partition function

SQL Server database creation

SQL Server PDW Connection Manager Editor

SQL Server PDW Destination

SQL Server PDW Destination Editor

staging database

Destination Editor

distributed table

DWLoader vs. Integration Services

replicated table

staging database

Parameter-based configuration model

connection managers

files retrieval, SQL task

default configuration

Description field

command-line switches

dynamic package executions

entry-point package

expressionable data flow component properties

Expression Builder dialog

package execution

package-level parameters

Parameterize UI

parameter values

Property Expressions Editor dialog

Required property, validation

Sensitive parameter

server environment variable

Solution Explorer

Variables window, SQL Server 307

Visual Studio configurations

Parent-Child patterns

Child-Parent variable pattern

dynamic child package

Create and Insert statements

DelayValidation property

Execute Package Task Editor

Execute SQL Task Editor

Foreach Loop Editor

packageListObject

Package List Table

parameter binding configuration

Precedence constraints

flow-based completion

non-standard notation

Success constraints

TRUNCATE TABLE execution

PreExecute method

Project Deployment Model

R

Reference Data Services (RDS)

ReleaseConnection method

RetainSameConnection property

S

Scripting patterns

design patterns

connection managers (see Connection managers)

naming conventions

variable data types

variable syntax code

variable visibility

custom tasks/components

external assemblies

script component

Project Explorer

vs. Script component

Shared-nothing architecture

Slowly changing dimensions (SCDs)

advantages and disadvantages

data flow components

large dimensions

optimal performance

small number of rows

third-party components

column change types

dimension table and keys

fixed and changing attribute options

historical attribute options

inferred dimension members

Software architecture

sp_MSforeachdb procedure

SQL Server Data Tools-Business Intelligence (SSDT-BI)

SQL Server Data Tools (SSDTs)

SQL Server Integration Services (SSIS) packages. See Execution patterns

SQL Server Management Studio (SSMS)

SQL Server PDW Connection Manager Editor

SQL Server Reporting Services (SSRS)

SQL Server source patterns

connection manager (see Connection managers)

Source Assistant

source component

ADO.NET data access

Data Flow design

data translations

OLE DB data access

OLE DB Source Editor

SSISDB database

SSIS execution and monitoring framework

monitoring execution

add variable window

AppPackageID variable

build instance tables and stored procedures

error logging (see Error logging)

Execute SQL Task Editor

Log Application Success

log.LogPackageFailure

log.LogPackageSuccess

log.SSISAppInstance table

log.SSISPkgInstance table and stored procedures

Log Start of Application

OnError event handler

parameter mapping page

succeed/fail SSIS package

test executions

parent–child pattern

cfg.AddSSISPackages Stored Procedure

cfg.Packages table

cfg Schema and cfg.packages table

Child1.dtsx package

package deployment model

Parent.dtsx package

project deployment model

Property Expressions Editor

SSISConfig database

User::ChildPackagePath

SSIS applications

add application

ApplicationName

ApplicationName variable

cfg.Applications and cfg.AddSSISApplication

cfg.GetSSISApplication statement

cfg.GetSSISApplication Stored Procedure

Child1 and Child2 SSIS packages

create cfg.AppPackages and cfg.AddSSISApplicationPackage

Foreach Loop Container Editor

many-to-many relationship

one-to-many relationships

User::ChildPackagePath variable

application instance data

Application Instance report

Application Instance report preview

application name

color Application Instance

Failed hyperlinks

Package Instance report

refreshed Application Instance report

rpt_ReturnAppInstanceHeader

rpt.ReturnAppInstanceHeader

rpt.ReturnAppInstanceHeader stored procedure

rpt.ReturnErrors Stored Procedure

rpt.ReturnEvents Stored Procedure

rpt.ReturnPkgInstanceHeader Stored Procedure

rpt Schema and rpt.ReturnAppInstanceHeader Stored Procedure

single application instance

Strong data types

T, U

biml listing file

dataflow XML node

lookup metadata

<ExecuteSQL> tag

<InputPath> tag

<OleDbDestination> tag

OleDbDestination node

OLE DB source adapter

output column nodes

TryParse() method

T-SQL data definition language (DDL) script

T-SQL MERGE statement

V

VariableDispenser.LockOneForRead() function

Variable mappings

Visual Basic for Applications (VBAs)

Visual Studio configurations

Vulcan technology

W

Windows Server 2008 R2

X, Y, Z

XmlReader class

XmlSerializer class

XML source component

column metadata

column-to-data-type mappings

connection manager

customers database table

IsSorted property value, advanced editor

Merge Join transform

output and column names generation

ScriptMain class

Select Script Component Type

simple element/subelement structure

SortKeyPosition property value, advanced editor

XML document, customer information

XmlReader class

XML Schema Definition Tool

XmlSerializer class

data flatten/denormalization

destination schema

XML task configuration

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

3.133.116.137