C

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]

caching
     reference
     servers
Call Stack window
casts
categories of connection managers
certificates (client)
Changing Attribute Updates data flow
channels, encrypting
Character Map Transformation Editor
Character Map transforms
checking source files in/out 2nd
checkins
     asymmetrical
     history
CheckSignatureOnLoad property
Choose Toolbox Items dialog box
choosing
     client certificates
     connection managers
CIMV2 namespace
classes
     base
     DTSBaseTaskUI
     task user interface foundation
         connection manager events
         connections
         debugging
         example
     WMI
         Logical Disk
         Logical MemoryConfiguration
         NetworkAdapter-Configuration
         Operating system
         PerfFormattedData_PerfOS_Processor
         Processor
         Service
         SystemDevices
         SystemUsers
         TimeZone
classifying components
clauses
Clean Solution command (Solution Explorer context menu)
Cleanup method
clients
     certificates
     SQLNCLI
code
     density (Script Task)
     Package containers
     snapshots
     source control
         branching
         checking in/out
         diffing
         labeling
         merging
         Source Repository
         syncing
collapsing containers
collections
     connections
     ExtendedProperties
     Package container
     RuntimeConnectionCollection
     values, extracting
Column Picker dialog box
columns
     error
     ErrorCode
     ErrorColumn
     establishing
     expressions
     external metadata
     Flat File Connection Manager configuration
     Fuzzy Lookup transform
     IDs
     mapping
     mappings 2nd
     output
     profiles
     ranking/sort order
     unneeded
Columns dialog box
     Delimited format
     fixed width
     ragged right
commands
     File menu (Visual Studio)
     Solution Explorer context menu
     SSIS menu
comments (Script Task)
Community menu (BIDS)
complexity of data flow constraint
Component Events interface
ComponentMetaData object
components
     access modes
     classifying
     column mappings
     custom editors
     customizing
         assembly references
         attributes, adding
         base classes
         building
         component types
         finding by runtime
         GAC installation
         guidelines
         output paths
         requirements
         solutions
         strong names
     data cleansing
         Fuzzy Grouping transform
         Fuzzy Lookup transform
    data flow [See data flow components.]
     Designer
     editing
     errors
         columns
         indicators
         outputs
     external metadata
     groups
     outputs
     proof-of-concept
     properties
     properties tables
     sample
         Data Profiler transform
         JPG File EXIF Reader Source Adapter
         ODBC destination adapter
         SQL Client destination adapter
         transform UI
     Script
         asynchronous outputs, creating
         custom logging
         destination adapters, creating
         overview
         performance
         proof-of-concept components
         source adapters, creating
         transformations, creating
         unusual/unsupported sources
computer names
Conditional Split transform
confidence
ConfigString property
Configuration Manager
Configuration Manager command (Solution Explorer context menu)
configurations (packages)
     creating
     DTS
     editing
     effects
     failure
     logging
     organizing
     overriding
     overview
     package paths
         acquisition information
         configurations
         indirect configurations
         syntax
     property values
     SSIS
     types
         Configurations Editor
         Environment Variable
         Parent Package Variable
         Registry Entry
         SQL Server Table
         XML
     warnings, filtering out
Configurations Editor
ConfigurationType property
ConfigurationVariable property
Configure ADO.NET Connection Manager dialog box
Configure Data Viewer dialog box
Configure Error Output dialog box
Configure OLEDB Connection Manager dialog box
Configure SSIS Logs dialog box 2nd
configuring
     ADO Connection Manager
     ADO.NET Connection Manager
     Analysis Services Connection Manager
     Audit transform
     BIDS source control
     connection managers
     data flow
         paths
         Task
         viewers
     data sources
     deployment utilities
     destination adapters
         DataReader
         Excel
         Flat File
         OLEDB
         RawFile
         Recordset
         SQL Server
     DSVs 2nd
     enumerators
     environment variable package configurations
     Excel Connection Manager
     Execute DTS 2000 Package Task
         embedding option
         inner/outer variables
         packages
         structured storage
     Execute Package Task
     Execute Process Task
     Execute SQL Task
     File Connection Manager
     Flat File Connection Manager
         advanced options
         columns
         previewing
         sourcefile/format
     Flat File Destination Adapters
     Foreach loops
     FTP Connection Manager
     FTP Task
     Fuzzy Grouping transform
         advanced settings
         connection managers, choosing
         householding
         input columns
     Fuzzy Lookup transform
         columns
         ETI
         reference data
         similarity threshold
     HTTP Connection Manager
     Integration Services Server
         access
         diagnostics
         executing packages, shutting down
         folders
         header
         MSDB Store
         restarting
     MSMQ Task
         Receive Mode
         Send Mode
     MultiFile Connection Manager
     MultiFlatFile Connection Manager
     ODBC Connection Manager
     OLEDB Connection Manager
     OLEDB Sources
     output paths
    packages [See configurations (packages).]
     scope
     Send Mail Task 2nd
     SMOServer Connection Manager
     SMTP Connection Manager
     source adapters
         DataReader
         Excel
         Flat File
         OLEDB
         RawFile
         XML
     surface area
     transforms
         Aggregate
         attributes
         Character Map
         column profiles
         Conditional Split
         Copy Column
         Data Conversion
         Derived Column
         Export Column
         Import Column
         Lookup 2nd
         Merge
         Merge Join
         Multicast
         OLEDB Command
         output buffer references, storing
         output columns, defining
         Percentage Sampling
         performing
         Row Sampling
         RowCount
         rows, profiling
         Sort
         Union All
     variable mappings
     Web Services Task
     WMI
         Connection Manager
         Data Reader Task
         Event Watcher Task
     XML
         Source Adapter
         Task
conflicting task names
Connect to Server dialog box
ConnectingToServer task log event
Connection Manager dialog box
     All tab
     Columns tab
connection managers
     ADO.NET
     categories
     communication with adapters
     configuring
     creating 2nd 3rd
     customizing
     database
     destination adapters, creating
     event handling
     file system
     files, accessing
     filtering
     Flat File 2nd
     FTP
     Fuzzy Grouping transform
     MSMQ
     network
     overview
     properties, adding to tasks
     RetainSameConnection property
     SMTP 2nd
     stock
         ADO
         ADO.NET
         Analysis Services
         Excel
         File
         Flat File
         FTP
         HTTP
         MSMQ
         MultiFile
         MultiFlatFile
         ODBC
         OLEDB 2nd
         SMOServer
         SMTP
         WMI
     substitution parameters for queries
     tasks 2nd
     WMI
Connection Managers dialog box
     Advanced tab
     Preview tab
Connection Managers window
connections
     acquiring
     DTS
     Integration Services Server
     lines (data flow vs. workflow)
     runtime
     scoping
     SSIS failure
     surface area configuration
     tasks 2nd 3rd
     tracking
connections collection method (Dts object)
Connections parameter (Execute method)
Connections Tray
ConnectionString property (MultiFile Connection Manager)
constraints
     amount of data to process
     amount of memory installed
     available memory
     baseline
     bottlenecks
     bus speed
     Business Intelligence Development Studio as
     common, list of
     complexity of data flow
     CPU cache/speed
     designer environment
     disk IO speed
     event handlers
     exploiting
     high-priority, list of
     identifying
     indexes
     logging
     network speed
     number of CPUs
     order of data
     other software running on the same machine
     package size
     performance
     precedence 2nd 3rd
     prioritizing
     query performance
     server availability
     tasks
     Theory of Constraints
         bottleneck processing, easing
         elevating bottlenecks
         exploiting
         identifying
         prioritizing
     unmeasured, deleting
contact information (Taskhost containers)
containers 2nd
     collapsing
     disabling
     EventHandler
     grouping
     hierarchy
     looping 2nd
     organization
     Package
         code
         collections
         properties
         structuring
     properties
         execution
         Expressions
         forced execution
         identification
         LoggingMode
         transaction
     scoping
     Sequence
     Taskhost 2nd
         contact information
         debugging
         graceful load failover
         isolation
         package paths
         persistence
         properties
         registration
         sensitive data protection
     workflow, organizing
Control Flow
     component context menus
         data flow paths 2nd
         data flow viewers 2nd
         error/warning indicators
         Flat File Destination Adapter, configuring
         Navigator window
         OLEDB Sources, configuring
     designer
     disabling
     Items toolbox
controlling package access
     SQL server storage
     SSIS server storage
Copy Column transform
Copy Column Transformation Editor
copying memory
counters
CPU cache constraint
CPU speed constraint
CreateDeploymentUtility property
CreateNewOutputRows method
creating [See building.]
CreationDate property
CreationName property
CreatorComputerName property
CreatorName property
credentials
CryptoTask task
CryptoTask task UI
     attributes
         debugging
         EnableDisable
         EnableExpandable
         foundation classes
         LocalizablePropertyCategory
         LocalizablePropertyDescription
         LocalizablePropertyName
         SortProperties
     DTSBaseTaskUI
     foundation classes
     hosted-view
     IDtsTaskUI
     IDTSTaskUIHost interface
     IDTSTaskUIView interface
     methods
     properties
     source files
     trees
customizing
     BIDS designer toolboxes
     components
         assembly references
         attributes, adding
         base classes
         building
         component types
         editors
         finding by runtime
         GAC installation
         guidelines
         output paths
         requirements
         solutions
         strong names
     connection managers
     data flow components
         Data Profiler transform
         design time 2nd
         JPG File EXIF Reader Source Adapter
         runtime 2nd
         sample transform UI
         source adapters
         SQL Client/ODBC destination adapters
     events
     Foreach Enumerators
     logging
         events
         providers
         script component
         Script Task
         SQL Task
     tasks
         connection managers
         feature properties
         identities
        SSIS-specific properties/methods [See SSIS (SQL Server Integration Services).]
     variables
CustomLogging.dtsx package