A

accessing package variables, 174

accessing SSIS design environment, 242–243

accumulated staging, 372

ActiveX Script Task

creating a new package with single Active X Script task, 170–172

implementing, 169–172

implementing custom code using, 174

Script Task and, 139

adding a new package, 380–381

adding a Sequence Container control flow item, 137

adding conditional split to find new customers, 378–379

adding configurations to a project, 297–298

adding connection manager for Fuzzy Lookup input, 138

adding data adapters, 43–49

OLE DB source data adapters, 43–44

adding error-handling code in Script Task, 146–148

adding Excel connection manager, 65

adding Execute SQL task, 129, 138

adding flat file destination, 379–380, 383–384

adding Foreach Loop containers, 130–132, 138

Sequence Container - File Exists, 130–132

adding Fuzzy Lookup transformation, 138

adding Lookup task process, 381–382

adding Script Tasks, 137

adding sequence containers, 121

adding SQL Server destinations, 127–129, 138

adding tables to find new dimension members, 376–377

adding variables, 137

additive measures, 353–354

Aggregate task

adding, 399–400

applying a configuration, 301–306

adding configuration to the  ImportCustomers.dtsx, 302–303

deleting existing package from SSMS, 302

deploying a package, 304

executing package, 306

executing package using configuration files, 306

inspecting alternate configuration files, 304–305

running deployed packages, 305

starting Package Installation Wizard, 304

applying precedence constraints, 132–136, 138

constraint values, 132

applying security, 292–294

assigning a value to variables, 122–123

assigning reader/writer roles to a package, 293–294

asynchronous tasks

defined, 437

asynchronous transformations, 73, 312

 attach_databases.bat script, 4

Audit transformation, 72

Autos window, 194