Microsoft® SQL Server® 2008 Integration Services: Problem-Design-Solution
by Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney
Index
Symbols
|| (Logical OR operator)
^ symbol
A
ACE OLEDB 12.0 (Microsoft)
active FTP
Adamson, C.
add process. See process add
ADO.NET
connection manager
dataset
destination adapter
advanced file management (archiving system/Script Task)
design section
accessing objects
custom assemblies
script languages
scripting
problem section
scenario for
solution section
access external assembly
archive the files
create external assembly
Adventure Works cube
Adventure Works DW 2008 catalog
AdventureWorks2008 Connection Manager
AdventureWorks2008 transactional system
AdventureWorksDW2008 database
ADO.Net connection manager and
AMO and
business keys in
DimCustomer table in
fact tables in
OLE DB connection to
Aggregate transformation
as blocking transformation
call center fact table and
defined
Editor
measure calculations and
Multicast and
agile methods
AMO (Analysis Management Objects)
Analysis Management Objects. See AMO
Analysis Services. See SSAS processing architecture
Analysis Services Execute DDL Task. See Execute DDL Task
Analysis Services Processing Task. See Processing Task
application factors (storage/deployment methods)
ApplicationConfiguration
archival and cleanup processes (scale-out ETL)
data file archival process
stage table clean-up process
archiving system (advanced file management/Script Task)
design section
accessing objects
custom assemblies
script languages
scripting
problem section
scenario for
solution section
access external assembly
archive the files
create external ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access