editing XML configuration file, 207–208
Employee connection manager, 47–49
EncryptAllWithPassword, 291, 292–293
EncryptAllWithUserKey, 291
encryption, 290–291
EncryptSensitiveWithPassword, 291
EncryptSensitiveWithUserKey, 291
EntryMethod property, 172, 174
environment variable, 208
configuring, 234
creating, 234
environment variable configuration creating, 213–215
environment variables creating, 212–213
environment variables, configuration, 202
error
no index content, 1
error count properties
changing, 260–261
Error Output, 190
error output, configuring, 102–111
adding data conversion transformation, 105–106
adding Flat File Destination for Lookup Errors, 108–109
adding Flat File Destination for successful lookups, 109–110
adding Lookup transformation, 106–108
creating a task, 104
creating/naming Flat File Source, 104–105
error options, 102
executing package/checking results, 110–111
exploring LookupGeography package, 102–103
fail component, 102
ignore failure, 102
opening/exploring package, 103
redirect row, 102
types of errors, 102
error-handling code
implementing in script, 173
ETL solutions
getting started, 2
evaluating configuration failure, 210
Event handler
defined, 10
event handler process control, 7–8
event handlers, 239–262
accessing SSIS design environment, 242–243
adding a task, 244
adding Execute SQL task, 244
adding Log Finish Execute SQL task to OnPostEvent event handler, 248–249
adding tasks to, 285
changing error count properties, 260–261
configuring the task, 245–247
connection manager settings, 257–258
creating, 241–262
creating a log to finish, 248–249
creating log error event handler, 250–251
creating task to move files with invalid data, 256–257
data flow transformations, 240
event handlers provided by SSIS, 241
Execute SQL task, 245–247
executing NewProducts.dtsx package and viewing results in Management Studio, 251–253
executing the package, 251–253, 261–262
mapping SSIS variables to SQL statement parameters, 247–248
OnError, 241
OnPostExecute, 241
OnPreExecute, 241, 243–244
OnTaskFailed, 241, 255
OnWarning, 241
preventing events from escalating to containers and packages, 259
QuickStartODS database, 242
tasks, 240
testing package with invalid data, 253–254
triggering, 240
Excel connection manager
adding to the Employee.xls file, 40–41
Excel connection manager, adding, 65, 66
Excel Destination data adapters, 46
adding Employee connection manager, 47–49
adding Excel connection manager, 66
Excel Destination data adapters, adding, 65
Execute Package, 32, 49–50, 66
execute package and review debug windows, 183
Execute Package task, 221–229
command-line utility, 227–228
DTExec, 222–223
DTExecUI, 222
executing tasks and containers and then disabling task and executing package, 224–226
extending package execution options, 224
SQL Agent, 228–229
SQL Server Agent, 224–226
SQL Server Import and Export Wizard, 221–222
SQL Server Management Studio, 223
starting Server Wizard from BIDS, 221
starting Server Wizard from Management Studio, 221–222
using Execute Package Utility, 226–229
Execute Package utility, 226–229
command-line utility, 227–228
SQL Agent, 228–229
Execute Process task, 224
Execute SQL task
adding, 138
adding to OnPreExecute event handler, 244
configuring, 245–247
configuring to run parameterized SQL statements, 247–248
Execute SQL tasks
adding, 129
execution plans, 331–333
execution trees, 312, 330
explicit transactions, 321
Export Column transformation, 72
expressions
building, 75
elements, 74–75
using in SSIS, 73–74
expressions, using in packages, 73–75
extract, transform, and load (ETL) process, 115