SSIS Concepts
What is SQL Server Integration Services (SSIS) ?
SSIS Project Architecture ?
What are the main components of SSIS Project Architecture ?
Control Flow:
Connection managers Variables
Parameters
Package Configurations
XML Configuration
Environment Variable Configuration
Parent Package Configuration
Registry Entries
SQL Server Configurations
Annotations
Package Configurations
Work Offline
Logging
Log Events
Check Points
Break Points
Transactions
SSIS Toolbox:
Favorites:
Dataflow Task
Execute SQL Task
Containers:
For Loop Container
Foreach Loop Container
Sequence Container
Task Host Container
Common:
Analysis Services Processing Task
Bulk Insert Task
Data Profiling Task
Execute Process Task
Execute Package Task
Expression Task
File System Task
FTP Task
Script Task
Send Mail Task
Web Service Task
XML Task
Other Tasks:
Analysis Services Execute DDL Task
Backup Database Task
CDC Control Task
Check Database Integrity Task
Data Mining Query Task
Execute SQL Server Agent Job Task
Execute T-SQL Statement Task
History Cleanup Task
Maintenance Cleanup Task
Message Queue Task
Notify Operator Task
Rebuild Index Task
Reorganize Index Task
Shrink Database Task
Transfer Database Task
Transfer Error Message Task
Transfer Jobs Task
Transfer Logins Task
Transfer Master Stored Procedure Task
Transfer SQL Server Objects Task
Update Statistics Task
WMI Data Reader Task
WMI Event Watcher Task
Control flow Properties:
Package Level Properties:
Delay Validation:
Propogate Property:
RetainsameConnection Property:
DisableEventHandler Property:
Checkpoint FileName
CheckPoint Usage:
Configurations
FailParentOnFailure
IsolationLevel:
LoogingMode:
MaxConcurrentExecutables
MaximumErrorCount
PackagePassword
ProtectionLevel
SaveCheckPoints
TransactionOption
Task level Properties:
Data Flow Task Properties:
DefaultBufferMaxRows
DefaultBufferSize
DelayValidation
DisableEventHandlers
EngineThreads
FailPackageOnFailure
FailParentOnFailure
LoogingMode:
MaximumErrorCount
TransactionOption
Solution Explorere Properties:
Solution File Properties:
Deploy:
Build:
Rebuild:
Convert to Package Deployment Model
Configuration Properties:
Debugging:
Data Flow Optimizations:
RunInOptimizedMode:
Debug Options:
InteractiveMode
Run64bitRuntime
Project Parameters
Connection Managers (Project Level)
SSIS Package Folder Properties:
New SSIS Package
SSIS Import and Export Wizard
Convert Deployment Model
Upgrade All Packages
Add Existing Package
Sort by Name
Miscellaneous
Data Flow:
Favorites:
Source Assistant:
Destination Assistant:
Parameters:
Event Handlers:
Executables:
Event Handler:
OnError
OnExecStatusChanged
OnInformation
OnPostExecute
OnPostValidate
OnPreExecute
OnPreValidate
OnProgress
OnQueryCancel
OnTaskFailed
OnVariableValueChanged
OnWarning
Package Explorer:
Execution Results:
Deployment:
Common Errors:
