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