Edit method, IDtsComponentUI interface, 473–475, 482
ellipses button (…), 72, 146
e-mail, sending with Send Mail task, 6, 62
e-mail transactions, payment processing case study
Data Flow processing for, 648–651
description of, 594, 596, 601
payment processing for, 645–647
Enable Identity Insert option, Bulk Insert task, 47
engines
Data Flow engine
definition of, 3, 311–312
optimizing, 361–363
runtime engine, 3, 5
Enterprise Edition, SQL Server 2005, 16–17
EntryPoint option, Script task, 60, 216
Environment Variable option, package configuration, 509
equal signs (==), equality operator, 146–147
Error List window, 32
ErrorDetail table, payment processing database, 608
errors. See also events; logging
in Aggregate transformation, 92
in Bulk Insert task, 48, 51
constraints acting on, 33–34
in data scrubbing, 134–138
detected at design time, 32
in Dimension Processing destination, 87
division by zero, in Aggregate transformation, 92
error outputs from bad data, 301–304, 425
in Execute Process task, 51
in Export Column transformation, 101
firing an event when errors occur, 220
handling, features for, 14–16
IErrorCollectionService service, 473, 486
in Import and Export Wizard, 23
in Lookup transformation, 350–351
in OLE DB source, 82
OnError event, 40, 399
precedence constraints handling, 391–398
Structured Exception Handling (SEH) for, 227–228
in task, failing package or parent, 44
in user interface for components, 486–488
ETL (extraction, transformation, and loading)
example of
copying data from source to destination, 119–124
creating derived columns during, 110–116
scrubbing data, 125–138
SSIS features for, 3
EvalOp property, 9
event handlers
definition of, 5, 14–15, 398
example of, 399–406
for Script task, 220–222
WMI Event Watcher task
configuring, 67–68, 514–515
definition of, 6, 67
example using, 521–522
Event Handlers tab, SSIS Package Designer, 39–40
events
bubbling, 406–408
definition of, 398
list of, 40, 399
logging, 414–416, 506–507
Events property, Dts object, 219, 220
examples. See also payment processing case study
Access
importing from, 253–255
using parameters with, 255–258
Aggregate transformation, 112
Application object, 496–504
Audit transformation, 135–138
Bulk Insert task, 48–51
checkpoints
in containers with transactions, 285–288
failing package, not sequence, 290
failing parent and package, 288–289
failing parent, not package, 288
list of, 290
in simple Control Flow, 280–285
without transactions, 289
Conditional Split transformation, 130–131, 351–352
copying data from source to destination, 119–125
Currency Conversion service, 265–272
Data Flow task, 122
data scrubbing (cleansing)
Conditional Split transformation, 130–131
connection for, 127–129
Data Flow for, 129
Derived Column transformation, 129–130
description of, 125–127
error handling, 134–138
Lookup transformation, 132
sending data to destination, 133–134
Union All transformation, 132–133
Derived Column transformation, 111
design practices, 357–358
DTC transactions
single package, multiple transactions using, 296–298
single package, single transaction using, 293–296
two packages, one transaction using, 298–299
ETL (extraction, transformation, and loading)
copying data from source to destination, 119–124
creating derived columns during, 110–116
scrubbing data, 125–138
event handlers, 399–406
Excel
exporting to, 240–244
importing from, 244–249
Execute SQL task, 48–51, 124, 148–150
File System task, 55–58
Flat File destination, 114
For Loop container, 75–78
Foreach Loop container, 78–80, 139–140
FTP task, 55–58
Fuzzy Grouping transformation, 180–182
Fuzzy Lookup transformation, 176–178
Hyperlink Extractor service, 262–265
images, importing, 151–154
Import Column transformation
file iteration, 155–157
importing images, 151–154
InfoPath documents, importing, 532–540
Lookup transformation, 132
massaging data, 110–115
Multicast transformation, 351–352
native transactions, 299–300
OLE DB Command transformation, 163–165
Oracle, importing from, 259–261
package management, 496–504
pipeline components
destination adapter, 419, 454–461
source adapter, 418, 432–443
transformation, 418, 443–454
producing Reporting Services report from RSS, 524–532
Row Count transformation, 161–162
Slowly Changing Dimension transformation, 192–200
Sort transformation, 113
Team System
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
Term Extraction transformation, 166–170
Term Lookup transformation, 172–173
Union All transformation, 132–133
Unpivot transformation, 186–189
Visual SourceSafe
branching, 565
checking in project, 555–556, 558, 559
checking out project, 554–555
creating project, 552–554
creating project in, 556–558
debugging project, 559–561
rolling back to earlier version, 561–564
Web site for, 417
WMI Data Reader task, 515–521
WMI Event Watcher task, 521–522
WQL queries, 66–67
XML, importing from, 272–278
Excel destination
configuring, 87
definition of, 12, 87
exporting to, 240–244
Excel source
configuring, 83
definition of, 12, 83
importing from, 244–249
uses of, 240
exceptions. See errors
Executable option, Execute Process task, 51
Execute DTS 2000 Package task, 5
Execute Package task, 6, 59
Execute Process task
configuring, 51–52
definition of, 6, 51
Execute SQL task
checkpoint in, example of, 280–285
configuring, 44–45, 144–145
definition of, 6, 44
example using, 48–51, 124, 148–150
uses of, 144
ExecuteOutofProcess option, Execute Package task, 59
Execution Instance GUID option, Audit transformation, 93
execution trees
definition of, 330–335
monitoring, 335–339
optimizing, 361–363
ExecutionStartTime option, Audit transformation, 93
ExecutionValue property, Dts object, 219
ExecValueVariable property, 44
ExistsOnDtsServer method, Application object, 493
ExistsOnSqlServer method, Application object, 493
Export Column transformation
configuring, 100–101
definition of, 13, 100, 159
example using, 159–160
as row-based, non-blocking transformation, 320
exporting data, to Excel, 240–244. See also Import and Export Wizard
Express Edition, SQL Server 2005, 16
Expression Builder, 72, 146–148, 210
Expression option, EvalOp property, 9, 34
Expression page, 72
ExpressionAndConstraint option, EvalOp property, 9, 34
ExpressionOrConstraint option, EvalOp property, 9, 34
expressions
conditional, for precedence constraints, 9, 34, 393–396
definition of, 208
property expressions
creating, 72, 146–148, 208–210
definition of, 72, 146, 208
regular expressions, 232
for task or transformation logic, 208, 211–213
external applications, using SSIS with, 523
Extract Column option, Export Column transformation, 100
extraction, transformation, and loading (ETL)
example of
copying data from source to destination, 119–124
creating derived columns during, 110–116
scrubbing data, 125–138
SSIS features for, 3