Learn How to Create SSIS Packages From Scratch Step By Step for SQL Server 2016/2019/2022
Instruction spans diverse Data Flow transformations, Control Flow containers, and database maintenance tasks like index rebuilding.
The teaching approach is noted as clear and suitable for those building a foundation through hands-on exercises.
Some demonstration scripts appear only on-screen rather than as downloadable files, and certain table creation scripts are missing.
One signal indicates that the Log Provider for Text Files may no longer be accessible via the UI in versions newer than SSIS 2016.
This trade-off makes sense for beginners looking for a structured introduction or experienced professionals performing a quick recap of core functionalities.
Score breakdown
The curriculum covers a wide range of transformations and maintenance tasks, providing significant technical breadth.
While the course includes hands-on elements, the lack of downloadable scripts for all demonstrations limits the ease of practice.
Instructional signals are mixed; while some find the teaching clear, others encounter difficulties with missing resources.
A specific report suggests that certain UI elements may have changed in versions following SSIS 2016.
The curriculum aligns well with the needs of both beginners and experienced professionals looking for a recap.
