Certification training

Create SSIS Packages Step By Step From Scratch

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

97Lectures
10h 22m 30sDuration
Vendor
Create SSIS Packages Step By Step From Scratch course cover Best seller
certification training 97 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

24 sections, 97 lessons, and lecture-level duration details.

01 Installing SQL Serever 2016 7m 44s
02 Installing SSDT 3m 51s
03 Setting Up Sample Database 5m 32s
04 Overview of SQL Server Integration Services (SSIS) 8m 41s
05 COMPLETE COURSE EXERCISE FILES 51s

01 Working with Import Export Wizard 6m 40s
02 Invoking Wizard From SSMS 3m 24s
03 Invoking Wizard From SSDT 9m 21s

01 Exporting Data From SQL Server To CSV File 9m 48s
02 Working with CharacterMap Transformation 7m 41s
03 Working with CopyColumn Transformation 4m 28s
04 Working with DerivedColumn Transformation 6m 51s
05 Working with PercentageSampling Transformation 7m 34s
06 Working with RowSampling Transformation 3m 27s

01 Working with Sort Transformation 4m 53s
02 Working with UnionAll Transformation 5m 28s
03 Working with Multicast Transformation 4m 16s
04 Working with ConditionalSplit Transformation 8m 27s
05 Working with Aggregate Transformation 9m 20s

01 Working with Audit Transformation 4m 24s
02 Working with ExportColumn Transformation 7m 41s
03 Working with ImportColumn Transformation 8m 45s
04 Working with Merge Transformation 8m 57s
05 Working with MergeJoin Transformation 8m 29s

01 Working with LookUp Transformation 7m 46s
02 Working with CacheTransform 14m 16s
03 Working with FuzzyLookUp Transformation 18m 10s
04 Working with FuzzyGrouping Transformation 9m 17s

01 Working with RowCount Transformation 8m 29s
02 Working with OLEDBCommand Transformation 5m 53s
03 Working with Pivot Transformation 7m 35s
04 Working with Unpivot Transformation 4m 48s

01 Working with TermExtract Transformation 9m 6s
02 Working with TermLookUp Transformation 6m 22s

01 Working with BulkInsert Task 8m 34s
02 Working with SequenceContainer Task 4m 15s
03 Working with ExecuteProcess Task 6m 24s
04 Working with ExecutePackage Task 8m 14s
05 Passing Parameters between Packages 3m 16s

01 Working with FileSystem Task 7m 2s
02 Working with WebService Task 13m 1s
03 Working with XML Task 13m 30s
04 Working with DataProfilingTask 6m 15s

01 Working with TransferDatabase Task 5m 31s
02 Working with TransferSQLServerObjects Task 2m 57s
03 Working with TransferMasterStoredProcedures Task 3m 20s
04 Working with TransferJobs Task 3m 44s
05 Working with TransferLogins Task 2m 33s
06 Working with TransferErrorMessages Task 4m 7s

01 Working with For Loop Container in a Fixed Manner 4m 30s
02 Working with For Loop Container in a Variant Manner 6m 26s
03 Working with For Each File Enumerator 9m 8s
04 Working with For Each Item Enumerator 5m 17s
05 Working with For Each From Variable Enumerator 4m 40s
06 Working with For Each Node List Enumerator 3m 32s
07 Working with For Each SMO Enumerator 5m 3s
08 Working with For Each ADO Enumerator 6m 28s

01 Using Configuration Files 14m 17s
02 Using Configuration Tables 5m 19s

01 Creating Dynamic Connection Managers 7m 42s
02 Creating Dynamic Tasks 5m 51s

01 Using Precedence Constraints 7m 44s
02 Handling Events 7m 15s

01 Working with Log Provider for Text Files 4m 57s
02 Working with Log Provider for XML Files 1m 55s
03 Working with Log Provider for Windows Event Log 2m 11s

01 Working with WMIDataReader Task - 1 9m 35s
02 Working with WMIDataReader Task - 2 7m 56s
03 Working with WMIEventWatcher Task 4m 46s

01 Sending and Receiving Messages with Message Queuing Task 10m 1s

01 Working with BackUpDatabase Task 5m 24s
02 Working with SQLServer Agent Job Task 3m 58s
03 Working with Execute T-SQL Task 2m 2s
04 Working with Update Statistics Task 8m 6s
05 Working with HistoryCleanUp Task 4m 35s
06 Working with ShrinkDatabase Task 4m 40s
07 Working with RebuildIndexes Task 5m 10s
08 Working with ReorganizeIndex Task 3m 15s
09 Working with CheckDatabaseIntegrity Task 4m 3s

01 Working with CheckPoints 6m 55s

01 Working with XML Source and RAWFileDestination 9m 18s
02 Working with RAWFileSource and SQLServer Destination 4m 56s
03 Working with ADO.NET Source and ADO.NET Destination 4m 22s
04 Working with RecordSet Destination 8m 40s
05 Working with DataReader Destination 4m 5s

01 Implementing Incremental Inserts 10m 36s
02 Updating Modified Records 5m 5s
03 Deleting Records 8m 28s

01 Configuring CDC 6m 15s
02 Implementing Initial Load 7m 42s
03 Implementing Incremental Inserts 8m 4s
04 Updating Modified Records 2m 13s
05 Deleting Records 2m 1s

01 Deploying SSIS Packages 4m 34s
02 Executing Packages Manually 5m 1s
03 Executing Packages through a Scheduler 3m 43s
04 Executing Packages through T-SQL 3m 48s
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.