F


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



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net