fact tables, 359–360
adding Data Conversion task, 401–403
adding Derived Column task, 400–401
adding Multicast task and Aggregate task, 399–400
adding new data flow to load fact table from staging table, 403
adding new package for fact table load processing, 398–399
adding OLE DB destination and configuring Error Output, 405–410
adding variable and Row Count task, 403–404
aggregating data in, 398
characteristics, 368
defined, 366, 411
loading, 398–410
managing, 397–410
transaction detail values, 368
Fail Component, 102
FailPackageOnFailure property, 264
FastLoad
enabling for OLE DB destination, 337
FastLoad option, 321
FastParse, 319
setting on Flat File Source, 337
features of book, 4
file system task
creating, 285
FileFound variable, 123
Finally block
StreamWriter objects and, 146
Flat File Connection Manager Editor, 83, 85, 93, 102, 103, 108, 109, 110
Flat File Destination
Lookup Errors, 108–109
successful lookups, 109–110
Flat File Destination - Employees CSV task, 22–23
Flat File destination data adapter, 92–93
Flat File Destination Editor, 93
creating and naming, 104–105
Flat File source, 80–82
configuring, 81
Execute package
creating data adapter, 81–82
delimited format text files, 80
fixed-width format text files, 80
ragged-right format text files, 80
Flat File Source Editor, 82, 85, 104, 105
Flat File Sources, 319
flat files
connecting to flat file destinations, 60
copying data from named query to, 57
For Loop container, 119
Foreach container
adding to Sequence container, 138
preventing Lookup Names task from escalating to, 259
Foreach containers
adding to Sequence Container - File Exists, 132
Foreach Loop container, 119, 176, 177, 179
Foreach Loop containers, 130–132
adding to Sequence Container - File Exists, 130
foreign keys
defined, 366, 411
Fuzzy Lookup
column width and, 125
Fuzzy Lookup input
adding connection manager for, 138
Fuzzy Lookup transformation
adding, 125–127, 138
adding an Execute SQL task, 129
adding SQL Server destination, 127–129
columns, 125
indexes and, 126
reference tables and, 125