A

Access

Excel source adapter for, 61–63

64-bit issues with, 307

ActiveX Script tasks, migrating to SSIS, 339, 351–352

administration of DTS packages, 335–339

administration of SSIS

command line utilities for, 299–301

firewall issues regarding, 299

in Management Studio

assigning package roles, 297–299

monitoring packages, 288–289

running packages, 290–297

performance counters, 308–309, 357

scheduling packages

with proxy accounts, 303–305

with SQL Server Agent, 301–303

troubleshooting, 303

when using central SSIS server, 284

tasks in, 6–7

ADO.NET Providers

for DB2, 331–332

for Oracle, 327, 328

ADO.NET sources, DataReader source adapter for, 60

Advanced Encryption Standard (AES), 40–44

Aggregate transformation

for data grain changes, 174

for maximum change identifier value, 77

for measure calculations, 160

AMO (Analysis Management Objects)

for partition management, 217, 218–220

processing SSAS objects using, 197, 216–217

Analysis Services Execute DDL Task

for partition management, 217–218

processing SSAS objects using, 197, 203–204

Analysis Services objects (SQL Server 2005 Analysis Services)

AMO (Analysis Management Objects) for, 197

attributes of, affected by ETL processing, 222–223

connection for, 198

control flow tasks for

Analysis Services Execute DDL Task, 197, 203–204

Analysis Services Processing Task, 197, 199–203

Execute Command Task, 197

cubes, processing, 192, 220–221

data flow destinations for

Dimension Processing destination, 197, 205–207

Partition Processing destination, 197, 207–208

data mining objects

data flow features for, 361

processing of, 192, 196

database, 192

dimensions, 192–194

measure groups

definition of, 123

processing of, 192

partitions

creating and modifying, 197–198

processing of, 194–195

processing methods for, 197

scheduling processing of, 191–192

security for, 198

types of objects processed, 192

XMLA scripts for, 197, 209–211

Analysis Services Processing Task, 197, 199–203

Analysis Services tasks, migrating to SSIS, 339

archiving

data staging used for, 66–67

File System Task for, 8, 352

ASCMD.exe executable

for dimension processing, 209–211

for partition management, 217–218

for partition processing, 211–214

assemblies

adding to GAC, 30–35

calling from Script Task, 33

creating, 27–29

referencing from local directory, 30

strong name for, 30–31

testing, 34–35

asymmetric encryption, 39

asynchronous transformation, 45, 360

attributes of dimensions, 92

Attunity Provider

for DB2, 332

for Oracle, 328

for VSAM, 332

auditing

audit table for, 68

event handling for, 226–229

log-based auditing, 68

package logs used for, 237

rows to be written, 13

SCD transformation outputs for, 118–119

SQL operations used for, 362

staging table for, 171

auto-incrementing identifier, 68