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