T

tab-delimited files as data source. See Flat File source

Table Lock option

Bulk Insert task, 47

OLE DB destination, 88

tables

dimension tables, 14, 107, 189–192

pivot tables, 106–107, 182–189

temporary, 157–159

task host container, 10, 73

task List window, 32

taskID option, Audit transformation, 93

taskName option, Audit transformation, 93

taskResult property, Dts object, 219

tasks. See also containers; packages; specific tasks

adding to controller flow, 43

available only in Enterprise Edition, 17

configuring, 33

creating, 27, 33

definition of, 5, 43–44

disabling, 43, 611

expressions for logic of, 208, 211–213

failure of, specifying effects of, 44

ID for, 44

list of, 5–6

logging for, 44, 413

name of, 44

outcome of, precedence constraints indicating, 391–393

output of, 44

precedence constraints for

arrow indicators for, 391–392

conditional expressions for, 9–10, 34, 393–396

constraint values, 9

creating, 33–34

definition of, 5, 9–10

error handling using, 391–398

multiple, 397–398

properties of

setting to expressions, 72, 146–148, 208–210

shared, list of, 43–44

validating at runtime, 43

synchronous execution of, 315–316

transaction for

isolation level of, 44

support for, 44

Team Foundation Server, 565–566

Team System

creating project in, 567–570

definition of, 547, 565

example using

branching code, 584

creating package, 573–579

labeling (striping) versions of code, 586–587

merging code, 585–586

shelving and unshelving, 583–584

version and source control, 579–583

MSF Agile template for, 570–572

Project Portal, 573

temporary tables, 157–159

Term Extraction transformation

available only in Enterprise Edition, 17

as blocking transformation, 322

data correlation by, 348

definition of, 14, 108–109, 165–166

example using, 166–170

Term Lookup transformation

available only in Enterprise Edition, 17

configuring, 171–172

data correlation by, 348

definition of, 14, 109, 171

example using, 172–173

as semi-blocking transformation, 321

TerminateProcessAfterTimeOut option, Execute Process task, 52

text. See also data; files

frequency of words in, determining with Term Extraction transformation, 14, 108–109, 165–170

matching, using Term Lookup transformation, 14, 109, 171–173

similar words in

finding with Fuzzy Grouping transformation, 13, 101, 178–182

finding with Fuzzy Lookup transformation, 13, 101, 173–178

Text File Log Provider, 506, 508

threads, optimizing, 361–363

Timeout option

Execute Process task, 52

Execute SQL task, 44

WMI Event Watcher task, 67, 515

tnsnames.ora file, 259

Toolbox, 29–30

Traditional Chinese operation, Character Map transformation, 94

Transaction property, Dts object, 219

TransactionOption property, 44

transactions

checkpoints and, 285–288, 289

DTC (Distributed Transaction Coordinator) transactions

definition of, 293

single package, multiple transactions using, 296–298

single package, single transaction using, 293–296

two packages, one transaction using, 298–299

in Import and Export Wizard, 21

native transactions

definition of, 293

example using, 299–300

for script container, getting, 219

for tasks, 44

types of, 293

Transfer Database task, 201–202

Transfer Logins task, 202–203

Transfer SQL Objects task, 204–205

Transfer Stored Procedures task, 203–204

Transformation Type Component, 228

transformations. See also specific transformations

available only in Enterprise Edition, 16–17

blocking nature of, 319–324

building from pipeline components

DeleteInput method, 448

DeleteInput method, 448

DeleteOutput method, 448

InsertOutput method, 447–448

PreExecute method, 448–450

ProcessInput method, 450–454

ProvideComponentProperties method, 443–445

ReinitializeMetaData method, 446

requirements for, 418

SetUsageType method, 447

Validate method, 445–446

communication mechanism of, 324–328

configuring, 90, 91

definition of, 13, 90

in DTS, 343–345

example of

copying data from source to destination, 119–124

scrubbing data, 125–138

expressions for logic of, 208, 211–213

list of, 13–14

types of, 318–319

Try block, 227–228