Cache, Global Assembly (GAC), 30–35
cache size, managing, 366–367
cached Lookup transformation, 136–137
candidate key (business key) of dimension table, 95, 144
change identifier columns
capturing maximum change identifier value, 76–79
definition of, 68
flat files containing, 82–83
process for using, 69
targeting change records, 69–72
updating package variables, 72–76
Change Type 0 (fixed attribute)
definition of, 102
implications on SSAS attributes, 222–223
Change Type 1 (changing attribute)
definition of, 102, 103
implications on SSAS attributes, 222–223
Change Type 2 (historical attribute)
definition of, 102, 103–104
with fact table ETL, 148
implications on SSAS attributes, 222–223
change types of dimension
in custom package, 137–141
implications on SSAS attributes, 222–223
inferred members, handling with, 104–106
list of, 102–104
specifying in SCD Wizard, 108–112
supported by SCD Wizard, 107
changing attribute (Change Type 1)
definition of, 102, 103
implications on SSAS attributes, 222–223
Changing Attributes Updates Output, SCD Wizard, 114
Check constraints option, OLE DB destination, 375
checkpoint files
definition of, 238
dynamic names for, 240–241
error handling for, 241–242
implementing, 238–240
using with transactions, 245
class libraries (assemblies)
adding to GAC, 30–35
calling from Script Task, 33
creating, 27–29
referencing from local directory, 30
strong name for, 30–31
testing, 34–35
cleansing of data
data profiling for, 48–52
example of, 177–180
transformations for, 97
clustering SSIS Service, 285–286
code page warnings from Oracle sources, 328
code reusability
reusable packages, 259–261
Script Tasks used for, 22
columns
creating rows from, 311–315
unused, removing from data flow, 367
command line utilities for SSIS administration, 299–301
common table expression (CTE), 355
The Complete Guide to Dimension Modeling (Kimball, Ross), 92
Conditional Split transformation
for change identifier columns, 82–83
for data grain changes, 174
for identifying fact table changes, 163, 165–166
for separating record types, 319
for separating valid and invalid data, 51
configurable connections, 35–37
connection manager
administration of, 291
creating, 7
Flat File Connection Manager
for file with multiple record types, 317, 318
migration to SSIS, 350–351
Local Temp DB Connection Manager, 346
Connection property, Analysis Services Execute DDL Task, 203
connections
choosing when running packages, 291
creating, 57
delaying validation of, 64
dynamic and configurable, 35–37
included with Windows and SSIS, 56
for SSAS integration, 198
updating with property expressions, 64–66
ConnectionString property, package, 36
containers
for SSAS objects, 192
types of, 19–20
Control Flow tab
precedence constraints, creating, 15–17
tasks, creating, 8
variables, creating, 8
corrupt packages, handling, 301
Create, Read, Update, and Delete (CRUD) operations, 69
CreateSymmetricKey() method, 40
CRUD (Create, Read, Update, and Delete) operations, 69
cryptographic key pair, 30–31
CTE (common table expression), 355
cubes (SSAS), 192, 220–221
CurrentRowWhere property, SCD Wizard, 118
custom scripts
Script Components
for data grain changes, 175
data profiling in, 49–52
encrypting data in, 39–48
language used in, 24
retrieving variables in, 26
Script Tasks
accessing and updating connections from, 36–37
calling assembly from, 33
code reusability with, 22
definition of, 22
language used in, 24
raising errors in, 37–39
retrieving variables in, 24–26
32-bit and 64-bit issues regarding, 307
user-defined variables for, 22–24