M


MachineName option, Audit transformation, 93

MachineName system variable, 38

mail, sending with Send Mail task, 6, 62

managed code, 491

ManagedDTS assembly, 426, 471, 492

Management folder, 388

Management Studio

managing DTS packages with, 388–389

managing SSIS packages with, 386–388

MapInputColumn method, 421

MapOutputColumn method, 421

MappingFiles folder, 384

MaxConcurrentExecutables property, 316

MaxErrors option, Bulk Insert task, 48

Maximum Insert Commit Size option, OLE DB destination, 88

Maximum operation, Aggregate transformation, 91

memory buffers, 317–318

Merge Join transformation

configuring, 104

data correlation by, 348, 352–354

definition of, 13, 103–104

as semi-blocking transformation, 321

Merge transformation

configuring, 103

definition of, 13, 102

restrictions on, 102

as semi-blocking transformation, 321

merging code, 585–586

Message option, Message Queue task, 63

Message Queue task, 6, 63

MessageSource option, Send Mail task, 62

MessageSourceType option, Send Mail task, 62

MessageType option, Message Queue task, 63

Method option, Web Service task, 64

methods, executing from Web service, 6, 63–65

Microsoft Distributed Transaction Coordinator (MSDTC), 293

Microsoft InfoPath documents, importing, 532–540

Microsoft Message Queue (MSMQ), sending or receiving messages from, 6, 63

Microsoft Solutions Framework SDLCs, 549

Microsoft Visual SourceSafe. See Visual SourceSafe

Microsoft.SqlServer.Dts.Runtime namespace, 492

Microsoft.SQLServer.ManagedDTS assembly, 492

migrating DTS packages to SSIS, 371, 373–380

Migration Wizard, 371, 373–380

Minimum operation, Aggregate transformation, 91

msdb database, saving packages in, 5, 384–385

MSDTC (Microsoft Distributed Transaction Coordinator), 293

MsDtsSrvr.ini.xml file, 386

MSF Agile template, 570–572

MSMQ (Microsoft Message Queue), sending or receiving messages from, 6, 63

MSMQConnection option, Message Queue task, 63

Multicast transformation

configuring, 104–105

definition of, 13, 104

example using, 351–352

staging data and, 360

as streaming, non-blocking transformation, 319

multiphase data pump, history of, 1



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net