E


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



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

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