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