SSIS - The Big Picture
- Course Introduction
- Installing SQL Server 2016
- Installing SSDT
- Setting Up Sample Database
- Overview of SQL Server Integration Services (SSIS)
- COMPLETE COURSE EXERCISE FILES
Data Migration Techniques
- Working with Import Export Wizard
- Invoking Wizard From SSMS
- Invoking Wizard From SSDT
Working with Data Flow Tasks - 1
- Exporting Data From SQL Server To CSV File
- Working with CharacterMap Transformation
- Working with CopyColumn Transformation
- Working with DerivedColumn Transformation
- Working with PercentageSampling Transformation
- Working with RowSampling Transformation
Working with Data Flow Tasks - 2
- Working with Sort Transformation
- Working with UnionAll Transformation
- Working with Multicast Transformation
- Working with ConditionalSplit Transformation
- Working with Aggregate Transformation
Working with Data Flow Tasks - 3
- Working with Audit Transformation
- Working with ExportColumn Transformation
- Working with ImportColumn Transformation
- Working with Merge Transformation
- Working with MergeJoin Transformation
Working with Data Flow Tasks - 4
- Working with LookUp Transformation
- Working with CacheTransform
- Working with FuzzyLookUp Transformation
- Working with FuzzyGrouping Transformation
Working with Data Flow Tasks - 5
- Working with RowCount Transformation
- Working with OLEDBCommand Transformation
- Working with Pivot Transformation
- Working with Unpivot Transformation
Working with Data Flow Tasks - 6
- Working with TermExtract Transformation
- Working with TermLookUp Transformation
Working with Control Flow - 1
- Working with BulkInsert Task
- Working with SequenceContainer Task
- Working with ExecuteProcess Task
- Working with ExecutePackage Task
- Passing Parameters between Packages
Working with Control Flow - 2
- Working with FileSystem Task
- Working with WebService Task
- Working with XML Task
- Working with DataProfilingTask
Working with ControlFlow - 3
- Working with TransferDatabase Task
- Working with TransferSQLServerObjects Task
- Working with TransferMasterStoredProcedures Task
- Working with TransferJobs Task
- Working with TransferLogins Task
- Working with TransferErrorMessages Task
Working with Control Flow - 4
- Working with For Loop Container in a Fixed Manner
- Working with For Loop Container in a Variant Manner
- Working with For Each File Enumerator
- Working with For Each Item Enumerator
- Working with For Each From Variable Enumerator
- Working with For Each Node List Enumerator
- Working with For Each SMO Enumerator
- Working with For Each ADO Enumerator
Working with Configuration Types
- Using Configuration Files
- Using Configuration Tables
Creating Dynamic Packages
- Creating Dynamic Connection Managers
- Creating Dynamic Tasks
Event Handling Techniques
- Using Precedence Constraints
- Handling Events
Working with Log Providers
- Working with Log Provider for Text Files
- Working with Log Provider for XML Files
- Working with Log Provider for Windows Event Log
Working with WMI Tasks
- Working with WMIDataReader Task - 1
- Working with WMIDataReader Task - 2
- Working with WMIEventWatcher Task
Using Message Queuing Techniques
- Sending and Receiving Messages with Message Queuing Task
Working with Maintenance Planning Tasks
- Working with BackUpDatabase Task
- Working with SQLServer Agent Job Task
- Working with Execute T-SQL Task
- Working with Update Statistics Task
- Working with HistoryCleanUp Task
- Working with ShrinkDatabase Task
- Working with RebuildIndexes Task
- Working with ReorganizeIndex Task
- Working with CheckDatabaseIntegrity Task
Implementing CheckPoints
