Welcome

- [Voiceover] Hi, my name is Ron Davis, and I'm the author of this course on Microsoft SQL Server Integration Services. SQL Server Integration Services is called a service because it is dependent on the SQL database engine having been installed. We use Integration Services to perform ETL, extract, transform, and load, where we reach out to flat files, the web, FTP, et cetera, and bring the data in and then transform it.

In this course, we'll be looking at the basic tools that allow you to create SQL Server Integration Services packages and how to connect those packages to your data sources. From there, I'll walk you through the basic tasks of preparation and loading your data so you can execute scripts, transform your data, and incorporate logic into how your data is treated. Along the way, we'll take a look at using events, debugging your workflows, and incorporating best practices, so let's get started on our journey to understand Integration Services.