SQL Server Integration Services (SSIS) - An Introduction

Phillip Burton

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
34 Videos (3h 46m)
    • Introduction

      1:48
    • Download SQL Server 2016

      7:50
    • Installing SQL Server

      13:49
    • Install SQL Developer Part 2

      12:34
    • Running SSMS and SSIS

      9:03
    • Looking around SSIS

      7:48
    • Data Flow Task

      6:14
    • Connection Manager

      7:56
    • OLE DB Source Task

      11:06
    • OLE DB Destination

      5:59
    • Data Viewer

      5:28
    • Practice Activity - Extract and Load

      4:03
    • Implicit Conversions

      6:25
    • Data Conversion

      8:23
    • Derived Column task

      8:14
    • Practice Activity - Altering Data Type

      4:23
    • Aggregation

      4:14
    • Multi-cast

      5:18
    • Conditional Split

      5:27
    • Error handling

      10:34
    • Row Sampling and Percentage Sampling

      3:29
    • Practice Activity - Aggregation

      2:32
    • Sort

      8:24
    • Adding an Excel source

      11:01
    • Add Text source and Excel destination

      8:17
    • Practice Activity - Percentage Sampling and Conditional Split

      3:48
    • Union All

      10:03
    • Merge and solving Mapping problems

      4:09
    • Add some auditing

      7:22
    • Adding different destinations

      4:09
    • Practice Activity - Different data sources, sort, merge and auditing

      2:28
    • Adding Variables and Row Count

      6:44
    • Script component

      4:53
    • Well done

      1:36

About This Class

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.

11

Students

--

Projects

0

Reviews (0)

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.