Expanded

Loading Data with SSIS

You know a little bit about SSIS, but what you’d really like to know is how to use it to move data from one place to another, maybe with a few data transformations thrown in for good measure. Watch the course and you’ll learn all of this and more!
Course info
Level
Beginner
Updated
Sep 2, 2020
Duration
2h 59m
Table of contents
Course Overview
Designing a Data Load
Building a Package
Loading Data
Implementing Events and Constraints
Fixing Package Errors
Custom Data Transfer Using the Script Component
Description
Course info
Level
Beginner
Updated
Sep 2, 2020
Duration
2h 59m
Description

Do you need to load information from a data source and move it to another place? Maybe you need to pick up data from some source files, modify the data, and load the rows into a database. Well congratulations, because you have come across the ideal course! In this course, Loading Data with SSIS, you'll learn all about data loading in SSIS, beginning with connection managers and executing SQL tasks. 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. 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 destination for data formats not supported natively by SSIS. 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 you can think of! Software required: SQL Server Development edition, SQL Server Management Studio, Visual Studio 2019 Community Edition, SSIS add-in for Visual Studio.

About the author
About the author

Mike loves to mess around with data and programming problems, the bigger the better. He’s worked with a variety of companies, helping to build and improve systems of all shapes and sizes.

More from the author
Building Your First VBA Module
Advanced
1h 57m
Nov 6, 2019
Developing for Excel with VBA
Advanced
2h 38m
Oct 29, 2019
More courses by Mike McQuillan
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello there, and welcome to Pluralsight! My name's Mike McQuillan, and do I have a course for you, all about loading data with SQL Server Integration Services. You might think SSIS is boring, just shifting data from one place to another. But it's actually a super interesting platform to work with. Honestly! Not only do you mess around with data, you also write SQL and .NET code. You even learn all about cool ways to transform data. SSIS developers need to be multi‑skilled, so it's a great string to add to your bow. With SSIS, you can take some boring, pity useless CSV files and turn them into something magical. You can load the data from the CSV files into a database, converting the rows into useful information as you insert them. Suddenly, a boring set of letters and numbers can give your organization insights into things they probably haven't even thought about. This course teaches you all you need to know about loading data. It even shows you how to handle data formats SSIS doesn't support natively using a script component with some cool C# code. You'll see the entire process from start to finish, beginning with designing and building a control flow. Lots of SSIS tasks are covered, showing how you can execute SQL, use foreach containers, and even sends emails. And we don't forget about making sure the package is configurable, either. With a good look, that's how variables and parameters can take your package to the next level, configuration‑wise, anyway. After you've learned all of that, you'll be shifting data from one place to another all of the time. Hope to see you at the course. Thanks for watching!