E


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 image from book 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 image from book 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




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

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