Course Features
Duration
179 minutes
Delivery Method
Online
Available on
Downloadable Courses
Accessibility
Mobile, Desktop, Laptop
Language
English
Subtitles
English
Level
Beginner
Teaching Type
Self Paced
Video Content
179 minutes
Course Description
Course Overview
International Faculty
Post Course Interactions
Instructor-Moderated Discussions
Case Studies, Captstone Projects
Skills You Will Gain
What You Will Learn
By the end of this course, you’ll know all the key concepts required to create solid SSIS packages that can transport data from one data source to another, and you'll have all the practical skills you need to load data into just about any format or system
First, you’ll see how a control flow can be designed and built, and how constraints can be used to direct the flow of the package
Next, you'll discover detailed coverage of data flows showing how data sources and transformations can be used to deliver top notch data to a target destination
Software required SQL Server Development edition, SQL Server Management Studio, Visual Studio 2019 Community Edition, SSIS add-in for Visual Studio
Then, you’ll even learn how variables and parameters can be used in expressions, making your package ultra-configurable and easy to manage and deploy! Finally, you'll find out how to create a custom Script Component, which can act as a data source or dest
You'll learn all about data loading in SSIS, beginning with connection managers and executing SQL tasks