UI for components. See user interface (UI) for components
UITypeName property, 468, 471, 475–476
Union All transformation
configuring, 109
data correlation by, 348
definition of, 14, 109
example using, 132–133
optimizing Data Flow and, 363
as semi-blocking transformation, 321
as streaming, non-blocking transformation, 319
Unpivot transformation
data cleansing and, 354, 355
definition of, 14, 107, 186
example using, 186–189
as semi-blocking transformation, 321
unshelving and shelving code, 583–584
Uppercase operation, Character Map transformation, 94
Use Passive Mode option, FTP task, 54
user interface (UI) for components
assembly for, 468–471
column properties for, 488–489
component properties for, 484–486
configuring component for, 468, 475–476
error handling, 486–488
form for
description of, 468, 476–477
form constructor, 477–478
populating controls, 478–480
responding to user input, 480–481
IDtsComponentUI interface, implementing, 467–468, 471–475
procedure for, 467–468
runtime connections for, 482–484
user variables, 37
UserName option, Audit transformation, 93
UserName system variable, 38
usp_BankBatch_Add table, payment processing database, 608–609
usp_BankBatch_Balance table, payment processing database, 610
usp_BankBatchDetail_Match table, payment processing database, 609–610