B | MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step

basic error detection and handling, 237–239

configuring transformation to fail when an error occurs, 239

configuring transformation to ignore errors, 239

configuring transformation to re-route error-causing records, 239

data flow transformations, 239

metadata lineage, 238

precedence constraints, 238

validation, 238

BI architects

getting started, 2

BI solution goals, 346–348

combining data from multiple sources, 347

providing fast and easy access, 347–348

BI solutions

choosing, 348

data granularity, 349–350

BIDS, 13–26

adding a Conditional Split transformation, 112

adding a connection manager, 112

adding a Derived Column transformation, 112

adding a Destination data adapter, 112

adding a lookup transformation, 112

adding a Multicast transformation, 112

adding conditional split transformation, 86–88

adding connections manager, 82–85

adding derived column transformation, 89–90

adding flat file destination data adapter, 92–93

adding multicast transformation, 95–96

adding SQL server destination data adapter, 97–99

creating a data adapter, 112

creating a data flow task, 112

creating a Flat File, 112

creating a task, 112

creating data adapter, 81–82

creating Data Flow task, 78–80

Data Flow designer, 69

Data Flow Task - Employee List, 19–20

defined, 32

docking utility windows, 16–17

editing an object, 112

executing CreateLists package, 24

executing package/checking results, 101, 110

executing the package, 94–95

exploring connection managers, 20–21

exploring SSIS projects in, 17–26

ImportCustomers package, 25–27

interface, 13

opening and exploring SSIS project, 76–77

opening the Derived Column - FullName task, 22

opening the Flat File Destination - Employees CSV task, 22–23

opening the OLE DB Source - Employee Query task, 21

opening the Sort - Department Shift Employee task, 22

opening the SSIS project, 112

opening/exploring package, 103

reviewing ImportCustomers package, 25

ScrapReason data source view in the Data Source view designer, 18–19

Solution Explorer, 15–16

viewing CreateLists package in the package designer, 19

viewing customer records files, 24–25

viewing final output, 23–24

viewing properties of derived column transformation, 91

BIDS (Business Intelligence Development Studio), 8–9

defined, 11

SQL Server Import and Export Settings Wizard, 8–9

Blocking transformations, 73, 313

testing packages with, 326–329

breakpoints, 176–181

setting, 177–181

setting and walk through code, 192–194

walk through code using, 190–194

Breakpoints window, 182

breakpoints, creating, 198, 199

buffer properties, working with, 323–324

buffer settings, 315–316

BufferTempStoragePath, 315

DefaultBufferMaxRows, 316

DefaultBufferSize, 316

buffer usage, 311–312

columns, 311

Data Pipeline engine, 311

row size, 311

BufferSize Tuning, 337

adding log event to, 337