I

ID property, 44

IDtsClipboardService service, 473

IDTSComponentEvents interface, 220

IDtsConnectionService service, 473, 482

IDtsVariableService service, 473

IErrorCollectionService service, 473, 486

images, importing, 151–154

Immediate window, 32, 224–225

Import and Export Wizard

accessing, 19

columns, mapping, 22

definition of, 2, 19

destination

creating table in, 22

specifying, 20

identity column, enabling, 22

package

executing, 22, 23

location of, 24

opening, 24

saving, 22, 23

protecting sensitive data, 23

source, specifying, 20

tables, specifying, 20

transaction, specifying, 21

Import Column transformation

configuring, 150–151

definition of, 13, 101, 150

examples of

file iteration, 155–157

importing images, 151–154

as row-based, non-blocking transformation, 320

Import statement, 218

importing data. See also Import and Export Wizard

from Access, 253–255

from Excel, 244–249

images, 151–154

from InfoPath documents, 532–540

from Oracle, 259–261

from RSS (Really Simple Syndication) file, 272–278

from XML file, 272–278

importing packages, 589–591

InfoPath documents, importing, 532–540

Initialize method, IDtsComponentUI interface, 472–473, 482

InsertInput method, 421, 448

InsertOutput method, 421, 447–448

Instant Client, Oracle, 259

Integration Services. See SSIS (SQL Server Integration Services)

InteractiveMode system variable, 38

Invoice table, payment processing database, 604–605

IsDestinationPathVariable option, File System task, 53

IServiceProvider assembly, 473, 482

IsLocalPathVariable option, FTP task, 54

IsolationLevel property, 44

IsQueryStoredProcedure option, Execute SQL task, 45

IsRemotePathVariable option, FTP task, 54

IsTransferAscii option, FTP task, 54

item enumerator, Foreach Loop container, 78

iteration, MSF Agile, 570

iterative SDLCs, 549–550