SQL Server Integration Services (SSIS) - An Introduction
- 4 hours on-demand video
- 6 articles
- 2 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Do Extraction, Transform and Load (ETL) tasks.
- You can use SQL Server tables, Excel spreadsheets and text files as your source.
- You'll be able to change data types, add columns, aggregate, split, sort and join
- You can then view what has been created, and save it to spreadsheet, database tables, or the clipboard.
- You don't need to have any prior experience with SQL Server.
- You don't even need to have it installed - we'll install the full Developer edition for free on your Windows machine.
- It would help if you have had some prior experience with T-SQL, but it is not essential.
"Instructor is easy to follow. He gives very clear examples. Course moves quickly enough to be engaging without skipping over material." -- Sarah Hale
"This course works for me because it progresses with a level of detail that will be useful as I think through each step necessary to execute my own integration packages. There are several courses to choose from and I'm glad I chose this one." -- David McNickle
"Very good introductory course. Didn't really know what SSIS was until recently. Working through the course opened my eyes to past projects that would have benefited from an SSIS ETL package or two." -- Stephen Benton
Welcome to this course about SQL Server Integration Services.
In this course you'll be downloading and installing the latest 2016 SQL Server Developer – a full version for free, so that you can use it on your machine. And previous versions of SQL Server Developer have previously retailed for around $100, and now it’s free.
So what is SSIS? It’s a way to automate in the importing and exporting and data – or ETL: extract, transform and load. It’s a very visual part of SSIS, using tasks, components and flowcharts, so it’s easy to learn the basics of it.
We’ll start by extracting some data, and then loading it into another table. I’ll take nice as slow as we start to introduce transformations, such as aggregation, conditional split, merging and auditing. There’ll be plenty of practice activities too, so you can get to practice your new-found skills. And if you are doing Microsoft certificates, it can help towards your 70-463 certification as well.
By the end of this course, you'll be confident in using the main Data Flow components and Control Flow tasks, and would be able to use it in your own work.
- You should take this course if you are not experienced in SSIS, or if you want to know what it is for.
- SSIS is good for automating certain processes, and is very visible.
- It is great for beginners, and good if you have had a little prior experience.
- As it is going through the basics, it is not useful if you commonly use SSIS.
- It can help towards your 70-463 certification.
It used to be that we had to install a cut-down version of SQL Server. Instead, let's now install a version with the full functionality of the Enterprise edition - for personal use only, though.
Wouldn't it be good to see what is happening internally? Let's add a data viewer and find out what goes between the two tasks.
Sometimes you just want to work on sample data. Let's find out how.
It's good to know through the data viewer how many rows there were - but can we get this information programmatically. Let's get the number of rows - but before we can do that, we need to work out how to use variables. And how do we see the results of this variable? Let's add a breakpoint, and then add a watch for that variable.