I

IDE (Integrated Development Environment), 142

Ignore Failure, 102

Immediate window, 195

implementing ActiveX Script Task, 169–172

implementing custom code in Control Flow, 173

implementing custom code using ActiveX Script Task, 174

implementing custom data processing code inside Data Flow, 173

implementing error-handling code in the script, 173

Import Column transformation, 72

ImportCustomers package

changing package protection level, 292

executing, 25–26

exporting deployed packages, 296

importing to file system, 295

reviewing, 25

role-based security, 293

running deployed packages, 305

 ImportCustomers.dtsx, 302

adding configurations, 302–303

changing package protection level, 293

deleting packages from SSMS, 302

executing file system package, 296

importing/exporting data

getting started, 2

indexes

dropping/disabling, 321

Fuzzy Lookup transformation and, 126

Input Output Selection dialog box, 89, 90

InputBuffer, 161–162

InputFile, 131

installing sample files, 3–4

Integrated Development Environment (IDE), 142

integrating data from heterogeneous source systems, 344

Integration Services Object Model, 9

Integration Services package, creating, 65

Integration Services, connecting to, 290

invalid data

creating task to move files, 256–257

testing package with, 253–254

is2005sbs database

adding OLE DB connection manager, 39–40

reviewing with Management Studio, 27

is2005sbsDW database

creating new diagram for, 355–356, 363–364

querying, 358, 364–365

resetting relationships for, 365, 366

iterative design optimization, 333–336

logging execution plans, 334–336