FailPackageonFailure property, 44, 280, 288–289, 412
FailParentonFailure property, 44, 288–289
FailtaskIfReturncodeIsNotSuccessValue option, Execute Process task, 52
Failure constraint value, 9
Fast Load option, OLE DB destination, 88
File Connection Manager, Web Service task, 64
file enumerator, Foreach Loop container, 78
File Extractor transformation. See Export Column transformation
File Inserter transformation. See Import Column transformation
File option, Bulk Insert task, 46
File Path Column option, Export Column transformation, 100
File System option, Execute Package task, 59
File System task
configuring, 53
definition of, 6, 52–53
example using, 55–58
FileConnection option, Execute SQL task, 45
FileCopy.dtsk file, 55
files
creating from blob-type fields in database with Export Column transformation, 100–101, 159–160
as data source
Flat File source, 12, 84, 121–122
Raw File source, 12, 84
iteration through, example of, 155–157
manipulating, 6, 52–58
storing as blob-type fields in database with Import Column transformation, 101, 150–157
FileUsageType property, 434
Finally block, 228
Fire Triggers option, Bulk Insert task, 47
FireBreakpointHit method, IDTSComponent Events interface, 220
FireCustomEvent method, IDTSComponentEvents interface, 220
FireError method, IDTSComponentEvents interface, 220, 486
FireInformation method, IDTSComponentEvents interface, 220, 221
FireProgress method, IDTSComponentEvents interface, 220
FireQueryCancel method, IDTSComponentEvents interface, 220
FireWarning method, IDTSComponentEvents interface, 220, 486
fixed-width files as data source. See Flat File source
flat buffers, 367, 368
Flat File destination
configuring, 88
definition of, 12, 88
example using, 114
Flat File source
configuring, 84
creating, 121–122
definition of, 12, 84
FolderExistsOnDtsServer method, Application object, 494
FolderExistsOnSqlServer method, Application object, 494
folders, manipulating, 6, 52–58
For Loop container
configuring, 75
definition of, 10, 74
example using, 75–78
Force Truncate option, Export Column transformation, 100
ForceExecutionResult property, 411
Foreach Loop container
definition of, 10, 78
example using, 78–80, 139–140
types of, 78
ForeachLoop.dtsx file, 78
ForLoop.dtsx file, 75
Format option, Bulk Insert task, 46
FTP task
configuring, 54–55
definition of, 6, 54
example using, 55–58
FTPConnection option, FTP task, 54
Full Width operation, Character Map transformation, 94
Fuzzy Grouping transformation
available only in Enterprise Edition, 17
as blocking transformation, 322
configuring, 179–180
data cleansing and, 354, 355
definition of, 13, 101, 178
example using, 180–182
Fuzzy Lookup transformation
available only in Enterprise Edition, 17
as blocking transformation, 322
configuring, 174–175
data cleansing and, 354, 355
data correlation by, 348
definition of, 13, 101, 173–174
example using, 176–178