A


Access database

configuring Connection Manager for, 251–252

importing from, 253–255

parameter, passing to SQL Command, 255–258

porting to SQL Server, 250

security for, 250–251

Access Upsizing Wizard, 254

ACH file, payment processing case study

Control Flow for, 635–638

description of, 595, 599–600

processing for, 643–645

processing requirements, 596

validation for, 639–643

AcquireConnections method, 425, 433–435, 455–456

ActionAtEvent option, WMI Event Watcher task, 514

ActionAtTimeout option, WMI Event Watcher task, 67, 515

ActiveX Script task, 5, 60, 61

adapters

Data Flow and, 328

destination adapters

building from pipeline components, 419, 454–461

definition of, 328

source adapters

building from pipeline components, 418, 432–443

definition of, 328

execution trees and, 330, 332

Admin account, Access, 251, 252

ADO enumerator, Foreach Loop container, 78

ADO.NET schema enumerator, Foreach Loop container, 78

Advanced Editor window

Import Column transformation using, 150–152

OLE DB Command transformation using, 105, 163

overriding with custom user interface, 475

Pivot transformation using, 182

Row Count transformation using, 161

synchronous and asynchronous transformations in, 324–328

Union All transformation using, 362

Unpivot transformation using, 188

when used by transformations, 91

Advanced Windowing Extensions (AWE), 304

AdventureWorksExtract.dtsx file, 110

AfterEvent option, WMI Event Watcher task, 67, 515

AfterTimeout option, WMI Event Watcher task, 67, 515

Aggregate transformation

as blocking transformation, 322–323

configuring, 91–92

data cleansing and, 354, 356–357

definition of, 13, 91

example using, 112

agile SDLCs

definition of, 549

MSF Agile template, 570–572

Allow Append option, Export Column transformation, 100

ampersands (&&), logical AND operator, 147

An Investigation of the Laws of Thought, on which are founded the Mathematical Theories of Logic and Probabilities (Boole), 548

Analysis Services Dimension Processing Destination transformation, 17

Analysis Services Execute DDL task, 5, 70

Analysis Services Partition Processing Destination transformation, 17

Analysis Services Processing task, 5, 70

annotations, 35–36

Application object

definition of, 492

methods of

example using, 496–504

package maintenance, 493

package monitoring, 495–496

package role maintenance, 495

server folder maintenance, 494

architecture of DTS, 342–343

architecture of SSIS

components of, 3–5

containers, 10

destinations, 12

DSVs (data source views), 8–9

packages, 5

precedence constraints, 9–10

sources, 7, 11–12

tasks in, 5–6

transformations, 13–14

variables, 10–11

arrows for precedence constraints, 391–392

ASP.NET applications, interfacing with, 540–545

assemblies, using in scripts, 225–226

AssemblyInfo.cs file, 428, 470–471

asynchronous transformation outputs

definition of, 325–326

execution trees and, 330

Audit transformation

configuring, 93

definition of, 13, 93

example using, 135–138

as streaming, non-blocking transformation, 319

auditing, system variables used for, 37–38

Auto Extend Factor option, Aggregate transformation, 92

Autos window, 32, 223–224

Average operation, Aggregate transformation, 91

AWE (Advanced Windowing Extensions), 304



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