Access database
configuring Connection Manager for, 251–252
importing from, 253–255
parameter, passing to SQL Command, 255–258
porting to SQL Server, 250
security for, 250–251
Access Upsizing Wizard, 254
ACH file, payment processing case study
Control Flow for, 635–638
description of, 595, 599–600
processing for, 643–645
processing requirements, 596
validation for, 639–643
AcquireConnections method, 425, 433–435, 455–456
ActionAtEvent option, WMI Event Watcher task, 514
ActionAtTimeout option, WMI Event Watcher task, 67, 515
ActiveX Script task, 5, 60, 61
adapters
Data Flow and, 328
destination adapters
building from pipeline components, 419, 454–461
definition of, 328
source adapters
building from pipeline components, 418, 432–443
definition of, 328
execution trees and, 330, 332
Admin account, Access, 251, 252
ADO enumerator, Foreach Loop container, 78
ADO.NET schema enumerator, Foreach Loop container, 78
Advanced Editor window
Import Column transformation using, 150–152
OLE DB Command transformation using, 105, 163
overriding with custom user interface, 475
Pivot transformation using, 182
Row Count transformation using, 161
synchronous and asynchronous transformations in, 324–328
Union All transformation using, 362
Unpivot transformation using, 188
when used by transformations, 91
Advanced Windowing Extensions (AWE), 304
AdventureWorksExtract.dtsx file, 110
AfterEvent option, WMI Event Watcher task, 67, 515
AfterTimeout option, WMI Event Watcher task, 67, 515
Aggregate transformation
as blocking transformation, 322–323
configuring, 91–92
data cleansing and, 354, 356–357
definition of, 13, 91
example using, 112
agile SDLCs
definition of, 549
MSF Agile template, 570–572
Allow Append option, Export Column transformation, 100
ampersands (&&), logical AND operator, 147
An Investigation of the Laws of Thought, on which are founded the Mathematical Theories of Logic and Probabilities (Boole), 548
Analysis Services Dimension Processing Destination transformation, 17
Analysis Services Execute DDL task, 5, 70
Analysis Services Partition Processing Destination transformation, 17
Analysis Services Processing task, 5, 70
annotations, 35–36
Application object
definition of, 492
methods of
example using, 496–504
package maintenance, 493
package monitoring, 495–496
package role maintenance, 495
server folder maintenance, 494
architecture of DTS, 342–343
architecture of SSIS
components of, 3–5
containers, 10
destinations, 12
DSVs (data source views), 8–9
packages, 5
precedence constraints, 9–10
sources, 7, 11–12
tasks in, 5–6
transformations, 13–14
variables, 10–11
arrows for precedence constraints, 391–392
ASP.NET applications, interfacing with, 540–545
assemblies, using in scripts, 225–226
AssemblyInfo.cs file, 428, 470–471
asynchronous transformation outputs
definition of, 325–326
execution trees and, 330
Audit transformation
configuring, 93
definition of, 13, 93
example using, 135–138
as streaming, non-blocking transformation, 319
auditing, system variables used for, 37–38
Auto Extend Factor option, Aggregate transformation, 92
Autos window, 32, 223–224
Average operation, Aggregate transformation, 91
AWE (Advanced Windowing Extensions), 304