F

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