S



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]

SafeMessageBox package
samples
     components
         Data Profiler transform
         JPG File EXIF Reader Source Adapter
         ODBC destination adapter
         SQL Client destination adapter
         transform UI
     Script Task
         exception handling
         Internet server files, downloading
         loading text files into variables
         log entries, creating
         message boxes, viewing
         packages, building
Save Copy of Package As command (Visual Studio File menu)
Save Package As command (Visual Studio File menu)
saving
     packages
     tasks
schemas
     logging
     queries
scope
     containers
         configurations
         connections
         event handlers
         execution
         LocaleID
         logging
         transactions
         variables
     variables
         Execute Package Task
         inheritance
         parent packages
         sibling containers
         variable hiding
Scope property
Script Component
     asynchronous outputs, creating
     custom logging
     destination adapters, creating
         connection managers
         scripts, adding
     overview
     performance
     proof-of-concept components
     source adapters, creating
         AcquireConnections method
         CreateNewOutputRows method
         email sources
         Interop assembly references, adding
         outputs, adding
         PostExecute method
         PreExecute method
         ReleaseConnections method
         rows, adding
     transformations, creating
         input columns
         scripts, adding
         SynchronousInputID property
         variables
     unusual/unsupported sources
Script Task
     ActiveX Script
     as placeholders
     assembly libraries, sharing
     breakpoints
     code density
     comments
     connection managers for accessing files
     custom logging
     Dts object
         connections collection
         ExecutionValue property
         IDTSComponentEvents interface
         Log method
         Logging method
         TaskResult value
         transaction object
         variables
     Editor
     exception handling
     functions, breaking up
     interactive mode
     junk code
     logging
     modal dialog boxes, avoiding
     progress messages
     project properties
     samples
         exception handling
         Internet server files, downloading
         loading text files into variables
         log entries, creating
         message boxes, viewing
         packages, building
     TaskResult, setting
     variables as parameters
Script Task Editor dialog box
Script Task project properties dialog box
ScriptObjectModel object [See Dts object.]
scripts, adding
     destination adapters
     Script Component transformations
ScriptTaskLogEntry event
security
     Agent Jobs
     Agent subsystems
         Jobs, creating
         paths
         permission problems
     multiple operation tiers
         access, segmenting
         sensitive package contents
         single machine packages
         user-defined roles
     nonpackage files
     packages
         access
         changes, detecting
         DontSaveSensitive
         EncryptAllWithLocalUserCredential
         EncryptAllWithPassword
         EncryptAllWithUserKey
         encryption
         EncryptSensitiveWithPassword
         EncryptSensitiveWithUserKey
         RemoveSensitive
         ServerStorage
     packages, accessing
     sensitive data
     signing requirements
     Simple File Sharing
     surface area configuration
     user-defined roles, creating
security identifiers (SIDs)
SECURITY namespace
Select Certificate dialog box
SELECT clause
Select Data Source dialog box
Select Package dialog box 2nd
Select Script Component Type dialog box
SELECT statements
Send Mail Task
     configuring 2nd
         message sources
         SMTP connection managers
     custom breakpoint
Send mode (MSMQ Task)
sensitive data
     identifying
     Taskhost containers
Sequence container
SequenceContainers package
server availability constraint
Server Explorer window
servers
     caching
     Integration Services
         configuring
         connecting
         properties
         remote connections
         restarting
         starting
     settings, viewing
ServerStorage protection level
Service class
services
     information, finding
     Meta Data
     surface area configuration
Set as Startup Object command (project context menus)
SetString method
sharing assembly libraries
SIDs (security identifiers)
signing requirements (packages)
similarity threshold
Simple File Sharing
Slowly Changing Dimension Columns dialog box
Slowly Changing Dimension transforms
     Fixed Attribute
     inferred member
     overview
     performance
     profile
     Type 1
     Type 2
     Type 3
Slowly Changing Dimension Wizard
     attribute change types
     data flow
         Changing Attribute Updates
         Fixed Attribute Output
         Historical Output
         Inferred Member Updates
         New Output
         Unchanged Output
     fixed/changing attribute types
     Historical Attribute options
     performance
     records, matching
     rows, processing
     running 2nd
     steps
     Welcome screen
SMOServer Connection Manager
SMTP Connection Manager 2nd 3rd
SmtpConnection property
snapshots (code)
Solution Explorer (Visual Studio)
     context menu
         build options
         Startup Projects dialog box
     data sources
     individual package context menus
     Project context menu
     Project Properties dialog box
     SSIS Packages Node context menu
solutions
     adding
     creating
     custom components
     opening
sort order (columns)
Sort transform
Sort Transformation Editor
SortKeyPosition property
     DataReader Source Adapter
     Merge transform
SortProperties attribute
source adapters 2nd
     AcquireConnections method
     creating
         AcquireConnections method
         CreateNewOutputRows method
         email sources
         Interop assembly references, adding
         outputs, adding
         PostExecute method
         PreExecute method
         ReleaseConnections method
         rows, adding
     Data Flow Task
     DataReader
         configuring
         IsSorted/SortKeyPosition properties
         profile
     design time methods
         AcquireConnections
         ProvideComponentProperties
         ReinitializeMetadata
         ReleaseConnections
         Validate
     DtsPipelineComponent attribute
     Excel
     Flat File
     Flat File Destination
     JPG File EXIF Reader
     OLEDB
     ProvideComponentProperties method
     RawFile
     Reinitialize method
     ReleaseConnections method
     responsibilities
     runtime approach
         buffer rows, adding
         column IDs, storing
         columns, establishing
         connections, acquiring
         data, inserting
         dispositions, handling
         EXIF data, reading
         files, looping through
         rows, ending
     Validate method
     XML
source control
     asymmetrical checkins
     BIDS
         configuring
         Pending Checkins window
         Solution Explorer
         Source Control menu
         Source Control toolbar
     branching
     checking in/out
     default directories
     diffing 2nd
     labeling
     merging
     multiple checkouts
     practices
     solutions, opening
     Source Repository
     SQL Server Management Studio
     syncing
Source Control menu
     checking in/out
     history, viewing
     latest version
     undo checkouts
Source Control toolbar
source files
Source Repository
source threads
SourceDB task log event
SourceFileConnectionManager property
SourceSafe Options dialog box
SourceSQLServer task log event
speeding up data flow
SQL Client destination adapter
SQL Profiler Log Provider
SQL Server
     2005 Setup and Upgrade forum
     Agent
     Deployment option (Package Installation Wizard)
     Destination Adapter 2nd
     Destination Editor
    Integration Services [See SSIS (SQL Server Integration Services).]
     Log Provider
     Management Studio
     Table package configurations
SQL Task 2nd
SQLIS.com
SQLNCLI (Microsoft SQL Server Native Client)
SSIS (SQL Server Integration Services)
     connection failure
     data transformations
     DTS, compared
     flow looping
     forum
     packages
     specific properties/methods, adding to tasks
         breakpoints
        Execute method [See tasks, executing.]
         ExecutionValue property
         InitializeTask method
         saving/loading
         Transaction object
         updating
         Validate method
         WaitForMe property
SSIS Import and Export Wizard command (SSIS Packages Node context menu)
SSIS menu
SSIS Packages Node Context menu
Standard tabs (stock tasks)
Standard toolbar (Object Explorer)
StandardErrorVariable properties
StandardOutputVariable property
Start Page (BIDS)
StarterTask task
starting
     Integration Services Server
     packages
StartTransferringObjects task log event
Startup Projects dialog box
statements
     INSERT
     SELECT
stock connection managers
     ADO
     ADO.NET
     Analysis Services
     Excel
     File
     Flat File
     FTP
     HTTP
     MSMQ
     MultiFile
     MultiFlatFile
     ODBC
     OLEDB 2nd
     SMOServer
     SMTP
     WMI
stock Foreach Enumerators
     Foreach ADO 2nd
     Foreach ADO.NET Schema Rowset
     Foreach File
     Foreach From Variable
     Foreach Item
     Foreach NodeList
     Foreach SMO
stock log events
stock log providers
     Designer Log Events
     SQL Profiler
     SQL Server
     Text File
     Windows Event
     XML
stock tasks
     access methods
     data-processing
         Bulk Insert
         Data Flow
         XML
     log events
         AfterOpen
         Begin
         BeginReceive
         BeginSend
         BufferLeak
         BufferSizeTuning
         ConnectingToServer
         DestSQLServer
         End
         EndReceive
         EndSend
         EventOccurred
         EventTimedOut
         ExecutingProcess
         ExecutingQuery
         ExecutionPlan
         ExecutionTrees
         FinishedTransferringObjects
         Initialization
         LogEntry
         Operation
         SourceDB
         SourceSQLServer
         StartTransferringObjects
         TaskBegin
         TaskEnd
         TaskInfo
         TaskTimeOut
         Variable Routing
         WSTaskBegin
         WSTaskEnd
         WSTaskInfo
     Script
     Standard tabs
     user interface
     workflow
         Execute DTS 2000 Package
         Execute Package
         Execute Process
         Execute SQL
         File System
         FTP
         MSMQ
         Send Mail
         Web Services
         WMI
         WMI Data Reader
         WMI Event Watcher
stopping packages
storage path properties
StorageLocation property
Stored Packages folder
storing
     column IDs
     DSNs
     objects
     output buffer references
     packages
         Management Studio
         SQL servers
         SSIS servers
     task user interfaces
string functions
strong names
summaries (text)
Summary window
Supported property
surface area configuration
Surface Area Configuration for Features dialog box
Surface Area Configuration for Services and Connections dialog box
Surface Area Configuration Wizard
synchronous outputs
SynchronousInputID property
syncing
system
     DSNs
     variables
         event parameters
         functionality support
         InteractiveMode
         package functions, controlling
         property values on objects
System Configuration Check dialog box
SystemDevices class
SystemUsers class
SystemVariable property



Microsoft SQL Server 2005 Integration Services
Microsoft SQL Server 2005 Integration Services
ISBN: 0672327813
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Kirk Haselden

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