MicroNugget: What is SQL Server Integration Services?

In this video, Garth Schulte covers SQL Server Integration Services. He explains how it is more than just another ETL tool. He shows you how you can use it to automate any operating system process. This includes those related to the command line, the file system, the Internet, the cloud, databases, the .NET engine and admin tasks.

After watching this video, you will understand what SQL Server Integration Services are and how you can use them to automate a variety of processes. Garth shows you that, while it is first and foremost a tool to allow you to get data into your SQL Server database, it is much more than just this. He describes how the tool is, in essence, a Swiss Army knife for all your backend needs.

He further describes all the ways in which you can automate processes using it. Then, he discusses all the components of the tool. This includes connections, tasks, events and variables.

Start learning with CBT Nuggets:

[brianlandis]

Great overview of SSIS. I needed to know what it is and what it does for a job I am applying to.

[osmiridium]

Good video and easy to understand, thank you!