Management Studio
accessing packages from, 288–289
administration of DTS packages using, 335
assigning package roles using, 297–299
running DTExecUI.exe utility from, 290–297
Maximum insert commit size option, OLE DB destination, 375
MDAC (Microsoft Data Access Components)
providers for, 61
sources from, 56
32-bit and 64-bit issues regarding, 307
measure groups (SSAS)
definition of, 123
processing of, 192
measures, in fact tables
calculations for, 159–161
definition of, 143, 145
memory utilization, 357–360
Merge Join transformation
for acquiring dimension surrogate key, 149, 155
for data grain changes, 174
for identifying fact table changes, 167–169
joining source data to dimension data, 133–136
Merge transformation, for data grain changes, 174
metadata
definition of, 86
in fact tables, 145
Microsoft Data Access Components (MDAC)
providers for, 61
sources from, 56
32-bit and 64-bit issues regarding, 307
Microsoft Data Warehouse Toolkit (Wiley), 102
Microsoft Distributed Transaction Coordinator (MSDTC), 243
Microsoft Providers
for DB2, 331
for Oracle, 327, 328
mining models (SSAS), 196.
See also data mining objects (SSAS)
mining structures (SSAS), 196.
See also data mining objects (SSAS)
msdb database
Package Store in, 287–288
roles in, used by package roles, 298
MSDTC (Microsoft Distributed Transaction Coordinator), 243
MsDtsServer service. See SSIS Service
MsDTSSrvr.exe executable, 354
MsDtsSrvr.ini.xml file, 284, 285
Multicast transformation
change identifier columns using, 77
data staging using, 66–67, 368