D

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

data
     cleansing components
         Fuzzy Grouping transform
         Fuzzy Lookup transform
     control flow
     high performance transformations
     manipulation transforms 2nd
         Aggregate
         Character Map
         Copy Column
         Data Conversion
         OLEDB Command
         Sort
     pipelines
     processing tasks
         Bulk Insert
         Data Flow
         XML
     queries
     sources
         configuring
         creating
         names (DSNs)
         overview
         views 2nd
         wizard
     transformations
Data Conversion Transformation Editor
Data Conversion transforms 2nd
data flow
     buffers
    components [See data flow components.]
     optimizing
         64-bit platform
         asynchronous transforms
         buffers, decreasing
         error handling
         fast drives, pointing to
         indexes
         internal IO transforms
         lookup reference data
         lookup/aggregate/sort transforms
         match indexes
         memory-intensive applications
         memory-intensive transforms
         operations, eliminating
         parallel execution
         partial/full cache mode
         row-intensive operations
         set-based operations
         Theory of Constraints
     performance
     Slowly Changing Dimension Wizard generated
         Changing Attribute Updates
         Fixed Attribute Output
         Historical Output
         Inferred Member Updates
         New Output
         Unchanged Output
     speeding up
    Task [See Data Flow Task.]
     workflow, compared
         connecting lines
         execution
         functional gamut
data flow components
     buffers, viewing
     context menus
     customizing
         Data Profiler transform
         design time
         JPG File EXIF Reader Source Adapter
         runtime
         sample transform UI
         SQL Client/ODBC destination adapters
     designer 2nd
     destination adapters
         input buffer data
         PreExecute method
         ProcessInput method
         properties
         ReinitializeMetaData method
     methods
         design time
         runtime
     paths 2nd
     properties
     property expressions
     source adapters
         AcquireConnections method
         DtsPipelineComponent attribute
         ProvideComponentProperties method
         ReinitializeMetadata method
         ReleaseConnections method
         runtime approach
         Validate method
     transforms
         attributes
         column profiles
         output buffer references, storing
         output columns, defining
         performing
         rows, profiling
         types
     validation
     viewers
Data Flow Path Editor dialog box
Data Flow Task 2nd 3rd
     adapters
     additive transformations
     Advanced Editor
     asynchronous outputs
     buffers 2nd 3rd
         conflicting settings
         DefaultBufferMaxRows property
         DefaultBufferSize property
         maximum/minimum sizes
         source metadata
         Subsystem
         width
     configuring
         Aggregate transform
         Data Conversion transform
         OLEDB Source Adapter
         Recordset Destination transform
     data formats supported
     error outputs
     Execution Engine
         execution plan
         execution trees
         parallel execution
     extensibility
     IDs
     inputs
     Layout Subsystem
     LineageIDs
     memory, copying
     optimizing
         64-bit platform
         asynchronous transforms
         buffers, decreasing
         error handling
         fast drives, pointing to
         indexes
         internal IO transforms
         lookup reference data
         lookup/aggregate/sort transforms
         match indexes
         memory-intensive applications
         memory-intensive transforms
         operations, eliminating
         parallel execution
         partial/full cache mode
         row-intensive operations
         set-based operations
         Theory of Constraints
     outputs
     overview
     paths
     performance
     pipeline components
     properties
         buffer size
         components
         deleting components
         engine threads
         storage paths
     side effects
     source adapters
     speeding up
     transforms
     truncations
Data Profiler transform
Data Source View Wizard
Data Transformation Services [See DTS (Data Transformation Services) packages.]
Data Viewers tab (Configure Data Viewer dialog box)
databases
     connection managers
     Northwind
     objects, moving
     Pubs
DataReader Destination Adapter
DataReader Source Adapter
     configuring
     IsSorted/SortKeyPosition properties
     profile
date/time functions
db_dtsadmin role
db_dtsltduser role
db_dtsoperator role
debugging 2nd [See also errors.] [See also troubleshooting.]
     breakpoints
     packages
     projects
     task user interfaces
     Taskhost containers
     windows (Visual Studio)
         Breakpoints
         Call Stack
         Locals
         Watch
Debugging tab (Project Properties dialog box)
DefaultBufferMaxRows property 2nd
DefaultBufferMaxSize property
DefaultBufferSize property 2nd
DefaultMaxBufferRows properties
DelayValidation property
Delete method
deleting
     column mappings
     columns
     debugging breakpoints
     packages from projects
     unmeasured constraints
delimited format
dependencies
Deploy Solution command (Solution Explorer context menu)
deploying packages (Deployment utility) 2nd
     as files versus into SQL Server
     File System Deployment option
     launching
     SQL Server Deployment option
Deployment utility 2nd
     File System Deployment option
     launching
     packages, moving
     SQL Server Deployment option
Deployment Utility tab (Project Properties dialog box)
DeploymentOutputPath property
Derived Column Transformation Editor
Derived Column transforms
     configuring
     examples
     profile
description property
     containers
     variables
design time
     data flow components
     methods
         AcquireConnections
         PerformUpgrade
         ProvideComponentProperties
         RegisterEvents
         RegisterLogEntries
         ReinitializeMetaData
         ReleaseConnections
        source adapters [See source adapters, design time methods, ReleaseConnections.]
         Validate
designers [See also BIDS (Business Intelligent Development Studio).]
     components
     environment constraint
     Foreach Loop
     groupings
     Log Events Log Provider
destination adapters 2nd
     creating
         connection managers
         scripts, adding
     DataReader
     Excel
     Flat File
     input buffer data
     ODBC
     OLEDB
     overview
     PreExecute method
         batch tables
         columns, mapping
         INSERT statements, creating
     ProcessInput method
     properties
     RawFile
     Recordset
     ReinitializeMetaData method
         destination table metadata, discovering
         external metadata columns
     SQL Client
     SQL Server
destination table metadata
     discovering
     external metadata columns
DestinationFileConnectionManager property
DestSQLServer task log event
diagnostic information (packages)
Diagnostic windows (Visual Studio)
     Error List
     Output
     Server Explorer
     Task List
dialog boxes
     Add File Connection Manager
     Add Reference
     Add SSIS Connection Manager 2nd
     Add to SourceSafe Project
     Choose Toolbox Items
     Column Picker
     Columns
         Delimited format
         fixed width
         ragged right
     Configure ADO.NET Connection Manager
     Configure Data Viewer
     Configure Error Output
     Configure OLEDB Connection Manager
     Configure SSIS Logs 2nd
     Connect to Server
     Connection Manager
         Advanced tab
         All tab
         Columns tab
         Preview tab
     Data Flow Path Editor
     Difference Options
     Don't Show Check In Dialog Box
     DTS Script Task: Runtime Error
     Edit Breakpoints
     End User License Agreement
     Excel Connection Manager
     Expression Builder
     Fixed and Changing Attribute Options
     Historical Attribute Options
     History Options
     Inferred Dimension Members
     Integration Services Properties
     Log Entry
     Logging Configuration
     modal, avoiding
     ODBC Connection Manager
     OLEDB Connection Manager
     Options
     Options (Visual Studio)
     Package Configurations
     Package Roles
     Project Dependencies
     Project Properties
     Script Task Editor
     Script Task project properties
     Select Certificate
     Select Data Source
     Select Package 2nd
     Select Script Component Type
     Slowly Changing Dimension Columns
     SourceSafe
     Startup Projects
     Surface Area Configuration for Features
     Surface Area Configuration for Services and Connections
     System Configuration Check
     Tables Schema Restrictions
     Windows Components Wizard
     WMI Data Reader Task Editor
Difference Options dialog box
diffing
diffs (source control)
digital signatures (packages)
Digital Signing command (SSIS menu)
direct input access method
directories
     fully qualified directories
     source control default
Directory namespace
Disable property
DisableEventHandlers property
disabling
     constraints
     control flow
     indexes
disk IO speed constraint
dispositions, handling
document warehousing
     Term Extraction transform
     Term Lookup transform
Don't Show Check In dialog box
DontSaveSensitive protection level
DownloadFileViaHTTP.dtsx package
downloading
     Internet server files
     Northwind database
     Pubs database
DSNs (Data Source Names)
DSVs (Data Source Views) 2nd
DTExec
DTExecUI
DTS (Data Transformation Services) packages 2nd
     connections
     creating
     data transformations
     Designer Components
     flow looping
     history
     installing
     IS similarities
     managing
     migration
         Enterprise Manager
         Execute DTS 2000 Package Task
         Meta Data Services
         Migration Wizard
         packages with passwords
         Upgrade Advisor 2nd
     packages
     settings
     SSIS, compared
     tasks
Dts object
     connections collection
     ExecutionValue property
     IDTSComponentEvents interface
     Log method
     Logging method
     TaskResult value
     transaction object
     variables
DTS Script Task: Runtime Error dialog box
DTSBaseTaskUI class
DtsConnection attribute
DtsForEachEnumerator attribute
DtsLogProvider attribute
DtsPipelineComponent attribute 2nd
DtsTask attribute
DTUtil