C

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