E

early binding approach, 26

Encrypt() method, 40

encryption

algorithms for, 40

extending Script Component for

capabilities for, 39

decryption code, 48

Rijndael encryption algorithm, implementing, 40–44

source and destination for, 45–47

of packages, 300–301

types of, 39

engine threads, 363

EngineThreads property, 370

EntryPoint property, Script Tasks, 24

error handling. See event handling

ETI Provider

for DB2, 332

for Oracle, 328

ETL (extraction, transformation, and loading).

See also data warehousing ETL;

dimension ETL;

fact table ETL

affecting SSAS attributes, 222–223

definition of, 1

scheduling of, 191–192

SSIS as appropriate tool for, 2–4

EvaluateAsExpression property, variables, 75–76

event handling

auditing through, 226–229

for checkpoint files, 241–242

disabling, 229

error events, raising in Script Tasks, 37–39

exception handling, when migrating DTS to SSIS, 344–352

snapshots used with, 229–233

types of event handlers, 225–226

for variable value changing, 24

Excel

64-bit issues with, 307

source adapter for, 61–63

exception handling, when migrating DTS to SSIS, 344–352.

See also event handling

Execute Command Task, 197

Execute DDL Task, 214–216

execute method, 382

Execute Process Task

ASCMD.exe executable used in, 210

migrating to SSIS, 339

Execute SQL Task

for acquiring dimension surrogate key, 149

location where executed, 377

migrating to SSIS, 339

execution trees

breaking up, 367–368

definition of, 363

extending SSIS, 21–22.

See also Script Components;

Script Tasks

extract files, breaking up with raw files, 246–251

extraction of data

configuring in Data Flow task, 8–9

data lineage, 55

definition of, 55

incremental extraction

approaches for, 68

with audit table, 68

with auto-incrementing identifier, 68

with change identifier columns, 68

correlating source with destination for, 83–86

definition of, 55, 68

with log-based auditing, 68

with timestamp data type, 79–81

objectives of, 55

process of, 56

extraction, transformation, and loading (ETL).

See also data warehousing ETL;

dimension ETL;

fact table ETL

affecting SSAS attributes, 222–223

definition of, 1

scheduling of, 191–192

SSIS as appropriate tool for, 2–4