C

Call Stack window, 181

Catch … End Try statements, 146

CD-ROM

inserting, 3

overview, 3

changing data, 352

changing DelayValidation property, 137

changing dimensions, 352

Chart Format viewer, 186

checkpoints, 263–284

benefits of, 263

configuring packages for, 264

exercises, 264–284

implementing, 281–284

choosing business intelligence solutions, 348

chunked accumulated staging, 373

Clear DimCustomer, 177, 180, 185

setting breakpoints and, 178, 179

colors, SSIS Designer, 180

columns

compatible data types, 125

combining data from multiple sources, 347

combining validated source data, 344

command-line utility, 227–228

Conditional Split transformation, 73

conditional split transformation, 85–88

configuration failure, 210

configuration files, 208–209

determining configuration order, 210

direct and indirect configurations, 209

environment variable, 208

evaluating configuration failure, 210

parent package variables, 209

registry entry, 209

SQL Server tables, 209

using multiple configurations, 210

configuration files, creating

testing new package configuration, 218

configuration files, creating multiple, 210–220

configuring environment variable, 213–215

creating a database environment, 212–213

creating database and OLE DB Connection Manager, 210–212

creating environment variable, 212–213

creating environment variable configuration, 213–215

creating Parent Package variable configuration, 219–220

creating ParentProductsDestination parent package, 219–220

creating SQL Server configuration, 215–217

creating SQL Server table, 215–217

exploring parent package, 218–219

testing new package configuration, 217, 220

viewing  ParentPackage.dtsx package, 218–219

configurations, 201–202

configuration benefits, 201–202

configuration types, 202

direct and indirect configuration, 202

environmental variable configuration, 202

parent package variable configuration, 202

registry entry, 202

specifying new XML configuration file location, 202

SQL Server table, 202

understanding XML configuration file, 202

XML, 202

configuring data flow transformations to ignore errors, 239

configuring left outer join merge join task, 377–378

configuring variable settings, 156–157

Connect To Server dialog box, 290

connecting to flat file destination, 60

connection manager, 35–50

adding data adapters, 43–49

adding Employee connection manager to Excel Destination data adapter, 47–49

adding Excel Destination data adapter, 46

adding localhost.is2005sbs Connection Manager to OLE DB Source data adapter, 44

adding from Data Source, 66

adding new, 39–41

adding Office Excel connection manager to the  Employee.xls file, 40–41

adding OLE DB connection manager for is2005sbs database, 39–40

adding OLE DB source data adapter, 43–44

creating a data flow, 41–42

creating SQL Server Integration Services project, 36–38

executing the package, 49–50

mapping to data adapter, 45–46

reviewing available types, 65

types, 35–36

connection manager settings, 285

setting, 257–258

connection manager, adding, 82–85

connection managers

exploring, 20–21

ConnectionString, 131, 138

ConnectionString property, 35

containers

defined, 10

containers, 119–125

adding sequence containers, 121

assigning a value to the variable, 122–123

creating a placeholder, 123–125

For Loop container, 119

Foreach Loop container, 119

Sequence container, 120

Task Host container, 120

testing whether output file is found, 122

Continue command, 191

Control Flow

creating breakpoints, 198

defined, 10

implementing custom code in, 173

reviewing variable status, 198

SSIS, 6

control flow components, 114–119

DelayValidation, 115

list of, 114

Control Flow tab, 29

control flow, debugging, 175–185

conventions in book, 4

copying data from named query to flat file, 57

Create Table dialog box, 98

CreateLists package, 24

CreateLists package in the package designer, 19

creating a data source, 50

creating a database environment, 212–213

creating data flow, 41–42

creating Data Flow Task, 65

creating data source views, 52

creating environment variable configuration, 213–215

creating environment variables, 212–213

creating Integration Services package, 65

creating named queries, 54

creating new databases, 211–212

creating new project for dimension table load packages, 375–376

creating new Script task and initiating code, 141–145

creating Parent Package variable configuration, 219–220

creating ParentProductsDestination parent package, 219–220

testing package with new configuraton, 220

creating placeholders, 123–125

creating SQL Server configuration, 215

creating SQL Server table, 215–217

creating XML configuration file, 204–207

CurrentRecord field, 390, 391

initializing for SCD reference, 391–392

custom code

implementing using ActiveX Script Task, 174

CustomSSISLog table, 246

Lookup Names, 254

Lookup Names task, 262

CustomSSISLogKey, 254